File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
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

problem in using poi api

swapnel surade
Ranch Hand

Joined: Mar 05, 2009
Posts: 129

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.

Paul Clapham

Joined: Oct 14, 2005
Posts: 19973

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.
I agree. Here's the link:
subject: problem in using poi api
jQuery in Action, 3rd edition