Sept. 6, 2010 HSSFCGI release for IBM System i
There is a new release - dated Sept. 6, 2010 - of the Easy400.net utility HSSFCGI.
This utility allows ILE-RPG programs to generate Excel spreadsheets with format XLS (Windows Office 2003) and XLSX (Windows office 2007).
The utility is based on Scott Klement's service program HSSFR4 and POI Java classes 3.2 and 3.6.
Everything (HSSFR4 and POI classes) is in the package.
OS/400 V4R3 or subsequent.
Open source and no-charge.
A special command, TABLEXLS, allows to generate spreadsheets directly from database files.
An intermediate XML-like XLSGEN stream file is generated and then processed
by spreadsheet generation commands (XLSGEN and XLSXGEN).
Documentation at page http://www.easy400.net/hssfcgi/html/page1.htm .
In previous HSSFCGI releases the spreadsheet generation commands (XLSGEN and XLSXGEN)
could not read intermediate XML-like XLSGEN stream file larger than 16 Mb.
The current HSSFCGI release removes the 16Mb restriction.
Giovanni B. Perotti