Re: Excel by XML generation

[Vernon Hamberg <vhamberg@xxxxxxxxxxxxxxx>]

Yep, Jon, that was probably I. But your and Susan's approach to write to 
the 2003 XML Spreadsheet format got me going in the first place.

Vern

On 12/15/2020 3:25 PM, Jon Paris wrote:
> There was a discussion on (I think) the RPG list a whole back on this topic - for some reason Vern comes to mind as a participant.  Haven't got time to look it up I'm afraid but somebody was doing it.
>
> Basically the approach is to generate a template spreadsheet, mark up the underlying XML where needed with placeholders, use templating system (in the past I've used CGIDEV2 for this) to modify the template and then zip the xml files up again.
>
>
>
> > On Dec 15, 2020, at 3: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