Re: XML Spreadsheets (CGIDEV2) - Progress and Problem

[Vernon Hamberg <vhamberg@xxxxxxxxxxxxxxx>]

Nice call.

If someone isn't aware, this is available on the easy400 dot net website 
- under the name HSSFCGI, I think - it doesn't use CGIDEV2, rather, it 
uses Scott Klement's POI service program.

As you say, Greg, it can probably do what Arnie wants - the XML here is 
a set of instructions to the service program.

One thing about using Scott's POI SRVPGM - for larger projects, I 
believe it can be rather slow. Everything it does is a separate Java 
call from RPG - creating a workbook object, creating each row, creating 
each cell, setting every attribute of a cell, etc.

But it does allow creating XLSX files, for Arnie, it might be the thing 
to use to get away from XML the 2003 Spreadsheet format that has long 
been out of use for the most part.

Cheers
Vern

On 10/26/2020 8:14 AM, Greg Wilburn wrote:
> What you are doing with CGIDEV2 can most certainly create the "newer" format .XLSX files.
>
> After creating the XML, Instead of using XLSGEN, you need to use XLSXGEN.
>
> I've used this for many years.
>
> HTH
>
> -----Original Message-----
> From: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxxxxxxxx] On Behalf Of Arnie Flangehead
> Sent: Monday, October 26, 2020 1:09 AM
> To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxxxxxxxx>
> Subject: Re: XML Spreadsheets (CGIDEV2) - Progress and Problem
>
> Thanks, Vern.
>
> I'll give it a go. I've got a fairly simple report coming up that
> would be a candidate for experimentation. I'll work through your
> explanation carefully. This is my first exposure to XML of any sort so
> it's still looking like a dense thicket of tangled weeds rather than a
> garden.
>
> On 10/26/20, Vernon Hamberg <vhamberg@xxxxxxxxxxxxxxx> wrote:
> > Yes, I found that the XML 2003 Spreadsheet format is quite limiting. I
> > believe that you can't include images in a spreadsheet with this format.
> >
> > I was curious about multiple worksheets, so I created a spreadsheet [...]