RE: systools.generate_spreadsheet

Thanks Gerald... I have it working in an RPG program (but I'm calling it).
I did not test this running under a standard user profile... I may run into issues given our exit point security software.

I think it's a nice addition to my toolbag, but... you lose a lot of granularities.
I have many RPG programs that use IFS tools I created to write data "row-by-row". Like you said, I can control the "column headers", delimiter, etc.



-----Original Message-----
From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of Gerald Magnuson
Sent: Wednesday, February 28, 2024 9:36 AM
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxxxxxxxx>
Subject: Re: systools.generate_spreadsheet

so I played around with this, and found the following:
1) testing from SQL scripts went fine, but when I put in a rpgle program I had to change authority on a directory in the path from PUBLIC *EXCLUDE to add QPGMR *USE.
2) I then had to WRKFCNUSG to allow QPGMR to use function QIBM_XE1_DDWNLD_RTOPCB

I let the developers know about this, as we have MANY reports that go out
as .xml via XML* builder modules, and .xml files are getting harder to
map to open with excel.
but alas, we also do a ton of column formatting that would be lost. so,
this winds up being a non-starter here.