Re: Excel by XML generation

[Vernon Hamberg <vhamberg@xxxxxxxxxxxxxxx>]

LOL - I remember the term, if I ever worked directly I've made sure I 
have forgotten!!

And we shall say nothing about DBase, right? Yikes, it seems still to be 
around in some form!

Vern

On 12/16/2020 10:00 AM, Richard Schoen wrote:
> Vern remember the good old SYLK days or was it SYLK ? 😊
>
> Regards,
> Richard Schoen
> Web: http://www.richardschoen.net
> Email: richard@xxxxxxxxxxxxxxxxx
>
> ----------------------------------------------------------------------
>
> message: 1
> date: Wed, 16 Dec 2020 09:44:39 -0600
> from: Vernon Hamberg <vhamberg@xxxxxxxxxxxxxxx>
> subject: Re: Excel by XML generation
>
> Hi Darren
>
> We use a method I was able to put together here a few years ago that uses functions from CGIDEV2 in RPGLE to do almost anything you have the courage, sometimes, to do - it's based on an original workbook created in Excel, as Jon described in one of his posts.
>
> I've given presentations on this and had open labs at COMMON to help get going in the methodology.
>
> The documentation for the various Excel formats exist - the 2003 XML Spreadsheet format is out there, search on that, although it is old and open to confusion.
>
> The XLSX format is described in documentation for the Office Open XML specification - it is official - and huge! You CAN roll your own - SEQUEL does, albeit limited to data dump with appropriate cell formats based on IBM i data types, I think.
>
> I just ran across a Powerpoint introduction to the SpreadsheetML markup language used for XLSX -
>
> http://download.microsoft.com/download/3/E/3/3E3435BD-AA68-4B32-B84D-B633F0D0F90D/SpreadsheetMLBasics.ppt
>
> Regards
> Vern