POWERUp 2019 has ended
Experience the magic of education. 
Back To Schedule
Wednesday, May 22 • 5:15pm - 6:15pm
48CE OPEN LAB: Fast Modern Excel (XLSX) Workbook Creation Using RPG

Log in to save this to your schedule, view media, leave feedback and see who's attending!

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. Suggested prerequisite: Fast Modern Excel (XLSX) Workbook Creation Using RPG

Learning Objectives:

1.Understand the internal structure of modern Excel (XLSX) files
2. Create a working program that will create an Excel file
3. Take away a usable shell as the basis for further development

avatar for Vernon Hamberg

Vernon Hamberg

Senior IT Developer, Ecolab, Pest Elimination
Vern has worked on IBM midrange systems for over 30 years, beginning with the System/38 and AS/400. At present he is a senior IT developer for the Pest Elimination division at Ecolab. He is degreed in both music and mathematics, which gives him a distinct approach to the art and science... Read More →

Wednesday May 22, 2019 5:15pm - 6:15pm PDT
Fantasy Tower Castle A-C
  • Level Intermediate
  • Operating System IBM i
  • Audience Developers who want to extend existing skills into writing modern business documents.