Our businesses often want reports delivered in Excel format. While there are several ways to create these spreadsheets using RPG, they all have some drawbacks. Writing to the current XLSX format for Excel spreadsheets may seem a formidable challenge, but we will see that the prospect of success is better than it might seem at first. And we will see how to use tools such as CGIDEV2 to accomplish the task of creating these modern, highly-functional spreadsheets. This is the first of 2 sessions, presenting the basic information needed to accomplish this task. The "advanced topics" session presents some interesting things that can be done using this methodology. Understand the internal structure of modern Excel (XLSX) files Identify various reporting scenarios, such as multiple sheets, static informational sheets, etc. Understand how to design and implement an Excel (XLSX) application
Learn why service programs are so awesome. We will weigh the pros and cons of different options we have for creating shared routines. We’ll learn how to create a service program and how easy it is to use these shared procedures in our applications. We will discuss the importance of binder source and how using it can make updating our service programs painless. 1. What is a service program 2. How to create a service program 3. How to use a service program
Whether your team admits it or not, we all have legacy code. In this session, we will explore easy ways to modernize these programs and improve performance. We will delve into these 3 specific situations: Converting RPG programs to SQLRPGLE Using SQL when multi-member files are in use Converting PF files to SQL tables
Jim Buck’s career in IT has spanned more than 35+ years, primarily in college education, manufacturing, and healthcare industries. Past president (13 years) of the Wisconsin Midrange Computer Professional Association (www.wmcpa.org) and has served on several teams developing IBM... Read More →
Thursday March 13, 2025 10:15am - 11:30am PDT
Madison
Our businesses often want reports in Excel format. There are several ways to create these spreadsheets using RPG, but they all have some drawbacks. While writing to the current XLSX format for Excel spreadsheets may seem a formidable challenge at first, we will see that things are not so bad as they might seem. And we will see how to use tools such as CGIDEV2 to accomplish the task of creating these modern, highly-functional spreadsheets. This is the second of 2 sessions that looks at more interesting things that can be done using this methodology. Understand challenges and opportunities when creating spreadsheets Understand the use of shared strings and learn how to implement them Understand grouping and outlining and learn how to implement them
