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 JSE/JEE APIs and the fly likes problem in using poi api Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Java » Other JSE/JEE APIs
Bookmark "problem in using poi api" Watch "problem in using poi api" New topic
Author

problem in using poi api

swapnel surade
Ranch Hand

Joined: Mar 05, 2009
Posts: 129
Hello,

I'm using POI API to read and create the excel file. Currently file is getting created but its not as viewable as the old file.
In new file its not taking proper column width so its not look like old file.
What should be done to overcome such problem.

Thanks
Paul Clapham
Bartender

Joined: Oct 14, 2005
Posts: 18991
    
    8

So which of these is your question?

(1) Why doesn't POI automatically set the width of columns to the number I am thinking of?

(2) How do I set the width of an Excel column in POI?

(3) Can POI set the width of an Excel column?

(4) How do I figure out what number to use for the width of a column?

(5) Why doesn't POI set the width of the column to the number I told it to use?

(6) ...

In other words: if you want people on the forum to help, then "what should be done" is that you should formulate a clear question. Have a look at our FAQ link TellTheDetails for more information.
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: problem in using poi api