aspose file tools*
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 Spring in Action this week in the Spring 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: 78
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
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: how to set coloumn width in excel sheet?