File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/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 Soft Skills this week in the Jobs Discussion 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
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: how to set coloumn width in excel sheet?