• 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

Problem with JExcel API

 
Greenhorn
Posts: 2
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Hi,

I am using JExcel API to create excel sheet reports. I am facing some problem with the same.

1. There is a requirement to have the headers (1st row of the sheet) printed on every page when we take a print out or view the preview. In excel, this can be achieved by specifying the "Rows to repeat at the top" in Page setup. But I am unable to set these in JExcel API.

2. If I render only a few rows in the excel sheet, the rest of the sheet appears grey in colour... Is it possible to overcome this problem?

Any immediate help in these two areas would be greately appreciated.

Thanks in advance.
 
SupriyaPS PS
Greenhorn
Posts: 2
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Hi,

Well.. the first issue seems resolved..
About the second one... Is there any function like setRepeatingRowsAndColumns() in JExcel?? This method is present in other Excel API's and can be used to setPrintTitles.

Thanks in advance.
 
Greenhorn
Posts: 21
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Hi SupriyaPS PS,

Can you tell me which other Excel API, you have used. I am looking for some Java API for Excel. I have tried using Apache POI, but this may have potential memory problem, coz I have a file which has hundreds of row and around 5 sheets.

I found from net that JExcel is a better API then POI, so am working on it. Do you know other API's which would be fine OR can you tell me what is your requirement for this api and how is the performance of JExcel ?

Regards,

Purav Gandhi.
 
Rancher
Posts: 43081
77
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Purav,
have you run into any actual problems with either POI or jExcelAPI, or are you just interested in potentially better solutions?

Note that the term "better" is relative to your requirements, which are unknown to us.
 
Purav Gandhi
Greenhorn
Posts: 21
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Hi Ulf Dittmer,
Actually, I have seen the following sun forum

http://forum.java.sun.com/thread.jspa?threadID=513505&tstart=150

I have a similar kind of problem. I am currently using POI, but the excel sheets I need to generate is small size, so no issues. But now that I need to generate too big sheet, I got to know that there is some potential problem in POI which would not allow us to generate that big a file with 5 sheets in it. I saw the forum and found that JExcel is better solution which makes files as big as 10MB. So thought to go with it.

Please give me your comments on same.

Regards,

Purav Gandhi
 
Ulf Dittmer
Rancher
Posts: 43081
77
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Well, it's easy to find out if you run into problems generating larger files. Since you already know the POI API, you can just give it a try, without much of an investment of time in learning it. To be on the safe side, you could make the files twice the size or so of what you actually need.
 
reply
    Bookmark Topic Watch Topic
  • New Topic