Re: EXCEL Spread sheet

Do you use a Windows system or something else?


Thanks,

Jason E. Olson
IBM i Engineer/Developer
josys36@xxxxxxxxx



On Wed, Jul 16, 2025 at 4:33 PM K Crawford <kscx3ksc@xxxxxxxxx> wrote:

I would like to get bitten but not sure where to start. Any thoughts on a
good step by step to get it installed and how to get started.
Kerwin

On Wed, Jul 16, 2025 at 3:53 PM Jason Olson <josys36@xxxxxxxxx> wrote:

Got bitten 5 years ago now. Haven’t recovered 😁

Thanks,

Jason E. Olson
IBM i Engineer/Developer
josys36@xxxxxxxxx


On Wed, Jul 16, 2025 at 3:47 PM Richard Schoen <

richard@xxxxxxxxxxxxxxxxx>

wrote:

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.


--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing

list

To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription

related

questions.

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing

list

To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related
questions.

--
Kerwin Crawford
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related
questions.