RE: Excel by XML generation

I hadn't looked at that, but a cursory perusal leaves me thinking this is another way to convert a data file into Excel. I could do that today with a .CSV dump. Problem with those is that you get very little flexibility in multiple sheets, styles, column headings, formulas, and other things we're able to do today.

-----Original Message-----
From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of Charles Wilt
Sent: Tuesday, December 15, 2020 3:45 PM
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxxxxxxxx>
Subject: Re: Excel by XML generation

CAUTION: This email originated from outside of the organization. Do not click links or open attachments unless you recognize the sender and know the content is safe.


Have you looked at using ACS directly on IBM i?

https://www.ibm.com/support/pages/automating-acs-data-transfer

Charles


On Tue, Dec 15, 2020 at 1:34 PM Darren Strong <darren@xxxxxxxxx> wrote:

We've gotten pretty good at generating spreadsheets with POI HSSF and
the JNI interface, but, the JNI interface is not efficient and the POI
HSSF versions march on while we've frozen our updates due to the move
to enums in that tool. Now, IBM has come a long way in helping us
generate XML and writing it to the IFS, which Excel is based on. Has
anyone had success generating the .xlsx file structure directly as XML
files and then zipping it up in the format that Excel likes? Is there
some documentation on the web I'm not able to find that might give some detail and examples on this?
I would guess that this method would be very fast compared to what
we're using now.


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

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

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

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