Re: EXCEL Spread sheet

[Jon Paris <jon.paris@xxxxxxxxxxxxxx>]

Scott included the instructions in his presentation on the website. But there is a copy of the relevant bits on IBM's tech exchange here: https://community.ibm.com/community/user/question/how-to-install-poi-36-on-ibmi-v7r4

	
Jon Paris
Jon.Paris@xxxxxxxxxxxxxx



> On Jul 16, 2025, at 3:24 PM, Slanina, John via MIDRANGE-L <midrange-l@xxxxxxxxxxxxxxxxxx> wrote:
>
> Yes, do you have the direction about installing all the POI file’s. I did download and install Scott files
>
> Thanks
> John Slanian
>
> From: K Crawford <kscx3ksc@xxxxxxxxx>
> Sent: Wednesday, July 16, 2025 3:21 PM
> To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxxxxxxxx>
> Cc: Slanina, John <jslanina@xxxxxxxxxx>
> Subject: Re: EXCEL Spread sheet
>
> ________________________________
> CAUTION: This email originated from outside of the PENCOR network. Do not click on any links or open attachments unless the sender is known, and the content is verified as safe.
> ________________________________
> if you want total control, column size, font, font color, cell color, images/logo in a cell etc.
> I have been using BNDDRI('HSSF').  once you get your head wrapped around it and create one program to use as a template very easy to recreate.
> this is where I started. https://scottklement.com/presentations/Excel%20Spreadsheets%20from%20RPG%20with%20POI.pdf
> Kerwin
>
> On Wed, Jul 16, 2025 at 1:58 PM Slanina, John via MIDRANGE-L <midrange-l@xxxxxxxxxxxxxxxxxx<mailto:midrange-l@xxxxxxxxxxxxxxxxxx>> wrote:
> I have been look for a ways to create Excel Spread sheet in native rpgle.
> All the sites that have information are down. All Scott links are down.
>
> I know I can dump a file to create via sql. But want to have more control then that.
>
> What is every ones  go to for that now ?
>
> Thanks
> John Slanina
>
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx<mailto: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<mailto: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<mailto: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.