The largest IBM i-related conference event in the world, bringing together the community of users, IBM, industry experts and solution providers.
Back To Schedule
Thursday, April 27 • 1:30pm - 2:30pm
136: No Limits Modern Excel Reports Using RPG

Sign up or 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.

Learning Objectives:
1. Understand the internal structure of modern Excel (XLSX) files
2. Identify various reporting scenarios, such as multiple sheets, static informational sheets, etc.
3. Understand how to design and implement an Excel (XLSX) application

avatar for Vern Hamberg

Vern 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 also serves on the COMMON Americas Advisory Council (CAAC) and SET and is one of the SMEs for... Read More →

Thursday April 27, 2023 1:30pm - 2:30pm MDT
Plaza Court 5
  Programming - RPG
  • Session Level Intermediate
  • Audience Developers who want to extend existing skills into writing modern business documents. Perhaps managers and administrators who want to know what is possible by leveraging existing knowledge.