Back To Schedule
Thursday, September 17 • 2:30pm - 3:25pm
Excel and IBM i: Creating Excel Docs from RPG

Sign up or log in to save this to your schedule, view media, leave feedback and see who's attending!

Excel and IBM i

Business Case:
Our businesses often want reports delivered in Excel format. In addition, they may ask for more advanced capabilities than a simple data extraction. We will see that we can say "Yes!" to these requests. Part I uses the CGIDEV2 tool create these modern, highly-functional spreadsheets. Part II discusses other ways to create Excel spreadsheets from IBM i data. We will cover several options at a high level, including interactive tools as well as programming techniques. More specifically, topics will include use of Access Client Solutions, other pre-made tools, and programming libraries for Java, Node.js, and Python.

Part I: Creating Excel Docs from RPG
Part II: Creating Excel Docs in a Multitude of Ways
Part III: LIVE Q&A and Panel Discussion

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 is degreed in both music and mathematics, which gives him a distinct approach to the art and science... Read More →

Thursday September 17, 2020 2:30pm - 3:25pm CDT
Application Development Room 1