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
