As you may know, HSSFCGI is an open-source utility for IBM System-i that allows to create Excel worksheets through a XML-like language named XLSGEN.
XLSGEN scripts can easily be generated from RPG programs.
HSSFCGI is distributed from site EASY400.NET, http://www.easy400.net . You can read about it at page http://www.easy400.net/hssfcgi/html/page1.htm .
Today news are two new "vertical" features of XLSGEN, working both for XLS and XLSX spreadsheets:
1- ROW HEIGHT
It is now possible to set the height of a row to a given number of points. Example:
<row row-height="210">
generates a row with a height of 210 points.
This is especially useful when you want to generate a row containing pictures, or when you want to generate a row containing big headings.
2- DATA VERTICAL ALIGNMENT
When a cell height (because of its row height) is vertically larger than its contents (example: some text), you may now provide some vertical alignment through keyword VALIGN. Example:
<cell>
<data type="text" valign="center" italic>this is a text string</data>
</cell>
(NOTE - HSSFCGI is built over Scott Klement's service program HSSFR4, an interface to POI Java classes)
Giovanni B. Perotti
HSSFCGI author
www.easy400.net site owner
XLSGEN scripts can easily be generated from RPG programs.
HSSFCGI is distributed from site EASY400.NET, http://www.easy400.net . You can read about it at page http://www.easy400.net/hssfcgi/html/page1.htm .
Today news are two new "vertical" features of XLSGEN, working both for XLS and XLSX spreadsheets:
1- ROW HEIGHT
It is now possible to set the height of a row to a given number of points. Example:
<row row-height="210">
generates a row with a height of 210 points.
This is especially useful when you want to generate a row containing pictures, or when you want to generate a row containing big headings.
2- DATA VERTICAL ALIGNMENT
When a cell height (because of its row height) is vertically larger than its contents (example: some text), you may now provide some vertical alignment through keyword VALIGN. Example:
<cell>
<data type="text" valign="center" italic>this is a text string</data>
</cell>
(NOTE - HSSFCGI is built over Scott Klement's service program HSSFR4, an interface to POI Java classes)
Giovanni B. Perotti
HSSFCGI author
www.easy400.net site owner