Loading…
Attending this event?
THE BEST IBM i & POWER SYSTEMS EDUCATION.When you come to POWERUp, you’ll be able to customize your experience. Choose from 300 sessions, covering over 20 areas of IT, when you plan your schedule. Visit the largest Expo of its kind and meet the experts behind the solutions. Attend social events to meet renowned speakers and peers alike. This conference is structured to give you the pure education and professional connections needed to best enhance your career. Are you ready to POWERUp?

Exhibitor Hall: https://www.expocad.com/host/fx/common/s24/exfx.html

Exhibitor Hall Map Here 
Back To Schedule
Tuesday, May 21 • 9:15am - 11:30am
195: No Limits Modern Excel Reports Using RPG-The Whole Story

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

Tweet Share
EVALUATION
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.

The first part of this session looks at what you need to get started with this approach. It also looks at the advantages of using CGIDEV2 to create Excel files.

The second part digs deeper into adding more features of Excel to your spreadsheets, optimization, and troubleshooting - what to do with that "unreadable content" message!

Learning Objectives:
1. Understand the internal structure of modern Excel (XLSX) files
2. Begin to get hold of the workings of CGIDEV2 and XML
3. Understand how to design and implement an Excel (XLSX) application
4. Get some idea of just what CAN be done to make even more useful spreadsheets
5. Learn what to do when...
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 →

Tuesday May 21, 2024 9:15am - 11:30am CDT
Meeting Room 203B 1508 Houston St, Fort Worth, TX 76102
  Programming - RPG
  • Session Level Intermediate
  • Audience Developers (and their managers) who are asked to create spreadsheets will see a way to get high functionality and good run-time performance.

Attendees (10)