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
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
 
jQuery in Action, 2nd edition
 
subject: how to set coloumn width in excel sheet?