10 pts.
 Hssfcgi xlsgen
I am using hssfcgi's xlsgen to create spreadsheet and the columns are not wide enough to contain all of the data. Has anyone ever used this process and how do I set the column width to auto fit. Thanks for your help.

Software/Hardware used:
rpg xls
ASKED: February 17, 2010  4:59 PM
UPDATED: February 18, 2010  7:08 PM

Answer Wiki:
Straight from the xlsgen web site: <quote> Setting the width and height is possible on a per column and on a per row basis. It's been exposed in the worksheet object for a while already (ColWidth, RowHeight, MultipleColWidth, MultipleRowHeight). With the Rows and Columns objects, it's possible to do the same for a whole range of rows and columns at once, and more consistently. Units are different whether we are talking columns or rows. For columns, it's a number of times a nominal character of size 8 points (rule of thumb : take a width in pixels, divide by 8). For rows, it's pixels. </quote> Google is your friend. See more at http://xlsgen.arstdesign.com/core/rowsandcolumns.html
Last Wiki Answer Submitted:  February 18, 2010  7:08 pm  by  Teandy   5,830 pts.
All Answer Wiki Contributors:  Teandy   5,830 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _