aspose file tools*
The moose likes Other JSE/JEE APIs and the fly likes Apache POI and Java Excel Library : getFitToPage() Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of The Java EE 7 Tutorial Volume 1 or Volume 2 this week in the Java EE forum
or jQuery UI in Action in the JavaScript forum!
JavaRanch » Java Forums » Java » Other JSE/JEE APIs
Bookmark "Apache POI and Java Excel Library : getFitToPage()" Watch "Apache POI and Java Excel Library : getFitToPage()" New topic
Author

Apache POI and Java Excel Library : getFitToPage()

Frank Wynants
Greenhorn

Joined: Oct 17, 2007
Posts: 4
Hi all,

I have the following problem :
- I create an Excel using Microsoft Excel.
- In the page-setup dialog I set the fit-to-pages option on and set fit to 1/5 pages.

Now when I read in this xls file with "Java Excel API" (http://jexcelapi.sourceforge.net/) I can't manage to get the correct value of the fit-to-pages option.

I can read in everything from the Excel file except this setting. What I try to do is :




I allready made some changes in the 'Java Excel API' to solve this but without succes.

Next step I took was downloading 'Apache POI'. But I have the exact same problem with this library. I can read in everything from the Excel sheet, except the boolean fitToPages. What I try to do using POI is :




Anyone knows what is going on and has a solution for this in either one of the 2 API's (I prefer "Java Excel API" over POI, but if you can give me solution for POI I will also be more than happy). I gues I am doing something wrong cause both libraries have the exact same effect but I have no idea...

greetings,
Frank
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Apache POI and Java Excel Library : getFitToPage()