Re: EXCEL Spread sheet

[Vern Hamberg <vhamberg@xxxxxxxxxxxxxxx>]

Hi John

I came up with a process maybe 12 years ago that lets you be very much 
in control. Basically you take an existing model, unzip it and find the 
sheet and other XMLs that it is composed of. Then make a template for 
use with CGIDEV2, then compress everything in the package into the XLSX 
file - the latter is actually a PKZIP kind of file.

I have a presentation, plus a lab, if you'd like to take a look. To a 
certain degree, you can do anything that Excel does, some stuff needs 
more effort.

*Regards*

*Vern Hamberg*

IBM Champion 2025 <cid:part1.QdRATL38.GJQGWHsQ@centurylink.net> CAAC 
(COMMON Americas Advisory Council) IBM Influencer 2023

On 7/16/2025 1:58 PM, Slanina, John via MIDRANGE-L wrote:
> I have been look for a ways to create Excel Spread sheet in native rpgle.
> All the sites that have information are down. All Scott links are down.
>
> I know I can dump a file to create via sql. But want to have more control then that.
>
> What is every ones  go to for that now ?
>
> Thanks
> John Slanina