Open source openpyxl<
https://openpyxl.readthedocs.io/en/stable/> is what I use in Python. Call from RPG using IBM Champion Richard Schoen's open source QshOni<
https://github.com/richardschoen/QshOni>
Jack Woehr
Independent Consulting Programmer
303-847-8442
jack.woehr@xxxxxxxxxxx
www.procern.com
Stay Connected!
New Name. Same Great Service.
NON-DISCLOSURE NOTICE: This communication including any and all attachments is for the intended recipient(s) only and may contain confidential and privileged information. If you are not the intended recipient of this communication, any disclosure, copying further distribution or use of this communication is prohibited. If you received this communication in error, please contact the sender and delete/destroy all copies of this communication immediately.
________________________________
From: RPG400-L <rpg400-l-bounces@xxxxxxxxxxxxxxxxxx> on behalf of Jim Oberholtzer <midrangel@xxxxxxxxxxxxxxxxx>
Sent: Thursday, March 7, 2024 8:52 AM
To: RPG programming on IBM i <rpg400-l@xxxxxxxxxxxxxxxxxx>
Subject: Re: Reading data from a SIMATIC.S7-1500 PLC
I know you specified RPGLE, but I’ll bet there is a Python alternative that could do it, and with a bit of engineering (See several threads on Ryver) you can call them from RPGLE and get the return. Beats needing to get Microsoft Excel into the mix which would require a PC of some sort.
As an Amazon Associate we earn from qualifying purchases.