Re: Install HSSFR4 questions

On Jun 23, 2020, at 5:23 PM, K Crawford <kscx3ksc@xxxxxxxxx> wrote:

John, I am not against that. I do not know Python, I am sure I can. Do
you have a link to a document that will explain what that will take. Or if
you would like to explain that would be okay.
To be honest I just want to get this working and show my coworkers it can
be done. Not sure how open they will be to Python. But if it is
straightforward to do this little task I think I can sell it to them.
Our clients are saying our reports and spreadsheets are old and need
updating. They are correct.
Kerwin

On Tue, Jun 23, 2020 at 3:53 PM John Yeung <gallium.arsenide@xxxxxxxxx>
wrote:

On Tue, Jun 23, 2020 at 3:56 PM K Crawford <kscx3ksc@xxxxxxxxx> wrote:

I have a need to have an RPG program create a xlsx.
I am reading Scott's PDF 'Excel Spreadsheets from RPG with POI.pdf' This
appears to be fairly old. Is there a newer document on how to install

it?

There will be people here who can help you out with that; you've
definitely come to the right place.

Personally, I recommend installing Python and XlsxWriter instead, and
calling those from RPG if it really needs to involve RPG at all.
(Depending on how much you've already invested in that RPG program, it
may make more sense to reengineer it as a Python program.)

If you happen to already be familiar with JavaScript, then feel free
to substitute Node.js for Python in my suggestion. But if you do
decide to try Python, I can actively help with that.

John Y.
--
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.

Help support midrange.com by shopping at amazon.com with our affiliate
link: https://amazon.midrange.com

--
KCrawford
--
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.

Help support midrange.com by shopping at amazon.com with our affiliate link: https://amazon.midrange.com