wood burning stoves 2.0*
The moose likes Other Open Source Projects and the fly likes how to set coloumn width in excel sheet? Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of The Java EE 7 Tutorial Volume 1 or Volume 2 this week in the Java EE forum
or jQuery UI in Action in the JavaScript forum!
JavaRanch » Java Forums » Products » Other Open Source Projects
Bookmark "how to set coloumn width in excel sheet?" Watch "how to set coloumn width in excel sheet?" New topic
Author

how to set coloumn width in excel sheet?

Nagaraj Shivaklara
Ranch Hand

Joined: Dec 16, 2008
Posts: 77
Hi,

I am using POI API ( poi-3.0-alpha1-20050704.jar )
I've created an Excel-sheet with the Jakarta POI API. I now want to autosize my columns, but I can't find a function in the API that can autosize my columns. The only thing I found is setColumnWidth. Can anybody point me out to an autosize-function in the POI-API.

Thanks
Nagaraj S K


Thanks n Regards,
Nagaraj S K
vinoth Robert
Ranch Hand

Joined: Feb 02, 2011
Posts: 31

hi dude

use poi 3.5

and there is a method autoSizeColumn(int column);

ex

sheet.autoSizeColumn(3);


vinoth.R
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: how to set coloumn width in excel sheet?