× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



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


As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:
Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.