Win a copy of Functional Reactive Programming this week in the Other Languages forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Apache POI and Java Excel Library : getFitToPage()

 
Frank Wynants
Greenhorn
Posts: 4
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic