Loading…
POWERUp 2020 has ended
Join your friends and colleagues in the COMMON community at POWERUp 2020. In the company of peers and over 100 industry experts, you’ll enjoy the best in Power Systems and IBM i education over the course of 4 days. View the list of nearly 400 sessions, which cover over 20 areas of IT. POWERUp also boasts the largest exposition of its kind. This conference is structured to give you the pure education and professional connections needed to best enhance your career. Are you ready to POWERUp?
Back To Schedule
Thursday, September 3 • 2:15pm - 3:15pm
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!

Tweet Share
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
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
Speakers
avatar for Vern Hamberg

Vern Hamberg

Senior Software Engineer, 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 software engineer for the Pest Elimination division at Ecolab. He also serves on the COMMON Americas Advisory Council (CAAC) and SET and is one of the SMEs... Read More →

Thursday September 3, 2020 2:15pm - 3:15pm EDT
Hanover AB
  RPG
  • LEVEL Intermediate
  • AUDIENCE Developers who want to extend existing skills into writing modern business documents.

Attendees (1)