We do the hard work way:
We just track every value we enter resp. its length as a String and hold an
array/list with an entry for the max. length (that is char count) of every
column. After filling of the sheet is complete, we go through the columns
and set every column width according to its matching measure. For this we
use a factor based on advice by POI, currently 256. This cuts longer texts
(hides the last chars), but works for usual cases.
In fact this is a bit ugly, since...
(a) the calculated length does not really handle cases like "iiiii" vs.
"WWWWW" with proportional fonts, witch would in turn require to calculate
the "real" (optical) width of the textual content based on font metrics data
:-( But Excel is not very good in doing this job also :-)
(b) *of course* it would be fine to have just an option associated with the
column that says "auto-fit". But as far as I can see, Excel does simply not
provide that: In fact it seems that Excel calculates the optimal width just
on (dialogue user) demand and sets the actual result of this computation as
new column width. :-(
hth,
--cg
On Wednesday, January 18, 2006 4:14 PM [GMT+1=CET],
[EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
> Hello,
>
> I try to define the layout of columns in POI.
> Is there a way in POI to set the column to the optimal width?
> In Excel you can achieve this by hand: Format-->Column-->Autofit
> Selection. Does POI provide a method doing the same?
>
> What I know is how to set a default width:
> ###
> HSSFSheet sheet = wb.createSheet("Test");
> ....
> sheet.setDefaultColumnWidth((short)20);
> ###
>
> Is there a smarter way?
> Many thanks in advanced!
> Thomas
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> Mailing List: http://jakarta.apache.org/site/mail2.html#poi
> The Apache Jakarta Poi Project: http://jakarta.apache.org/poi/
Regards,
--
Dipl.-Inform. Christian Gosch
Systems Development
inovex GmbH
Karlsruher Strasse 71
D-75179 Pforzheim
Tel.: +49 (0)72 31 - 31 91 - 85
Fax: +49 (0)72 31 - 31 91 - 91
mailto:[EMAIL PROTECTED]
http://www.inovex.de
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
Mailing List: http://jakarta.apache.org/site/mail2.html#poi
The Apache Jakarta Poi Project: http://jakarta.apache.org/poi/
