• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

Apache POI and Java Excel Library : getFitToPage()

 
Greenhorn
Posts: 4
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
 
reply
    Bookmark Topic Watch Topic
  • New Topic