Re: Utility for import excel file to db2 file

Openpyxl in Python.
Create a Python virtual environment.
pip install openpyxl
Write simple program in Python.
Call it from RPG.

________________________________
From: RPG400-L <rpg400-l-bounces@xxxxxxxxxxxxxxxxxx> on behalf of gio.cot via RPG400-L <rpg400-l@xxxxxxxxxxxxxxxxxx>
Sent: Saturday, February 1, 2025 08:11
To: 'RPG programming on IBM i' <rpg400-l@xxxxxxxxxxxxxxxxxx>
Cc: gio.cot <gio.cot@xxxxxxxxxxx>
Subject: Utility for import excel file to db2 file

I'm looking for an free utility (if exist), to invoke from RPG program, for
import data from excel to Ibm i file; could you share which
command/programs do you use ?



Jack Woehr
Independent Consulting Programmer

303-847-8442

jack.woehr@xxxxxxxxxxx

www.procern.com

Stay Connected!

Not Just MSP, We Also MSSP.

 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.