Loading…
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

Speakers
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