Re: EXCEL Spread sheet

Need to get bitten by the Python !!

XLSXWRITER, OPENPYXL and Pandas are good options.

So easy these days to wrap them in CL or call from RPG.
https://www.github.com/richardschoen/qshoni

Regards,
Richard Schoen
Web: http://www.richardschoen.net
Email: richard@xxxxxxxxxxxxxxxxx

------------------------------

message: 2
date: Wed, 16 Jul 2025 14:27:16 -0500
from: Jason Olson <josys36@xxxxxxxxx>
subject: Re: EXCEL Spread sheet

At this point I do that with a Python library called XLSXWRITER.

But from what I have read you can do that directly in RPG

https://www.rpgpgm.com/2024/01/creating-excel-spreadsheets-with-sql.html

At one point in time there was someone who was wrapping XLSXWRITER to be used directly in RPGLE, but I can't find any mention of it now. The only thing I did find was like 5 years old.