Re: Excel by XML generation

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