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
