Re: XML Spreadsheets (CGIDEV2) - Progress and Problem

That's exactly the approach we use and that I present from time to time. It does have its difficulties, yet it allows for features that might be hard to do, if at all, in other methods.

I've not used the PHP or PYTHON tools - we just had a module at the COMMON virtual powerup on this - a fellow on Jesse's team presented the open source options - and there ARE lots of options there - and modules like XLSXWriter in Python that let you dig pretty deep, as I understand it.

Cheers
Vern

On 10/26/2020 10:41 AM, Jon Paris wrote:

If I recall correctly the CGIDEV2 approach can be used to create XSLX files but you have to unzip the base excel file into its components, set the appropriate "bits" as the templates, and then zip up the resulting output of the CGIDEV2 functions.

Doable - but not easy.

With the advent of easy tools like those available from php and python (just to name two) it is probably far more trouble than it is worth.

On Oct 26, 2020, at 11:06 AM, Vernon Hamberg <vhamberg@xxxxxxxxxxxxxxx> wrote:

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

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