Re: Utility for import excel file to db2 file

[Jon Paris <jon.paris@xxxxxxxxxxxxxx>]

Scott Klement has POI interfaces if you want to stick with RPG.  See https://www.scottklement.com/poi/

  
Jon Paris
Jon.Paris@xxxxxxxxxxxxxx



> On Feb 1, 2025, at 11:18 AM, Jack Woehr via RPG400-L <rpg400-l@xxxxxxxxxxxxxxxxxx> wrote:
>
> 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.
> -- 
> This is the RPG programming on IBM i (RPG400-L) mailing list
> To post a message email: RPG400-L@xxxxxxxxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: https://lists.midrange.com/mailman/listinfo/rpg400-l
> or email: RPG400-L-request@xxxxxxxxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at https://archive.midrange.com/rpg400-l.
>
> Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related questions.