Tweet
HSSFCGI is a free open source utility distributed from site www.easy400.net (free registration required).
HSSFCGI allows to create Excel xls and xlsx workbooks on IBMi.
HSSFCGI is based on Scott Klement's HSSFR4 service program.
The utility runs on IBMi V5R3, V5R4, V6R1 and V7R1 operating system releases.
HSSFCGI is based on a simple XML-like language called XLSGEN.
HSSFCGI commands XLSGEN and XLSXGEN can process XLSGEN scripts to generate Excel workbooks.
With the XLSGEN language you can:
- create worksheet rows and cells
- define column-heading, text, numeric, date and formula cells
- choose among a number of character sizes and decorations at cell level
- select text alignment at cell level
- set foreground and background colors at cell level
- include pictures in cells
- provide hyperlinks
- define print headers and footers(*)
XLSGEN scripts can be easily generated from programs and run by XLSGEN/XLSGENX command to obtain Excel workbooks.
A special facility is also provided by command TABLEXLS.
With this command, without writing any line of code, you can directly create an Excel workbook from up to 50 database files (*) in a single shot.
Multimember (*) data base files can be processed: you may select members, or take them all.
This command features
- automated generation of column headers
and includes the following options
- page headers (*)
- print headers (*)
- background colors for column headers
- foreground and background colors for the other cells
- picture inclusion
- hyperlink support.
A WEB interface to command TABLEXLS is also available, with the same features.
By using this interface, the generated Excel workbook is directly sent to the browser for download.
Please refer to HSSFCGI documentation at page http://www.easy400.net/hssfcgi/html/page1.htm .
Giovanni B. Perotti
www.easy400.net site owner
==============================
Items marked by (*) have been made available on February 21, 2011 HSSFCGI release.
HSSFCGI allows to create Excel xls and xlsx workbooks on IBMi.
HSSFCGI is based on Scott Klement's HSSFR4 service program.
The utility runs on IBMi V5R3, V5R4, V6R1 and V7R1 operating system releases.
HSSFCGI is based on a simple XML-like language called XLSGEN.
HSSFCGI commands XLSGEN and XLSXGEN can process XLSGEN scripts to generate Excel workbooks.
With the XLSGEN language you can:
- create worksheet rows and cells
- define column-heading, text, numeric, date and formula cells
- choose among a number of character sizes and decorations at cell level
- select text alignment at cell level
- set foreground and background colors at cell level
- include pictures in cells
- provide hyperlinks
- define print headers and footers(*)
XLSGEN scripts can be easily generated from programs and run by XLSGEN/XLSGENX command to obtain Excel workbooks.
A special facility is also provided by command TABLEXLS.
With this command, without writing any line of code, you can directly create an Excel workbook from up to 50 database files (*) in a single shot.
Multimember (*) data base files can be processed: you may select members, or take them all.
This command features
- automated generation of column headers
and includes the following options
- page headers (*)
- print headers (*)
- background colors for column headers
- foreground and background colors for the other cells
- picture inclusion
- hyperlink support.
A WEB interface to command TABLEXLS is also available, with the same features.
By using this interface, the generated Excel workbook is directly sent to the browser for download.
Please refer to HSSFCGI documentation at page http://www.easy400.net/hssfcgi/html/page1.htm .
Giovanni B. Perotti
www.easy400.net site owner
==============================
Items marked by (*) have been made available on February 21, 2011 HSSFCGI release.
Comment