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 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 EJB 3 in Action this week in the EJB and other Java EE Technologies 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()
 
Similar Threads
IO - POI - HSSF
How tochange the values in an existing Excel file by using POI?
error : upload excel file
use Apache POI to read Excel file problem
Read a .xls,.xlsx file format using XSSF