This week's giveaway is in the Android forum.
We're giving away four copies of Android Security Essentials Live Lessons and have Godfrey Nolan on-line!
See this thread for details.
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 Android Security Essentials Live Lessons this week in the Android 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?
 
Similar Threads
unable to open excel document
where to keep data
POI issue
handling Date Cell in POI eventuserModel
Apache POI