• Post Reply Bookmark Topic Watch Topic
  • New Topic

Problem with JExcel API

 
SupriyaPS PS
Greenhorn
Posts: 2
  • Mark post as helpful
  • send pies
  • 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
  • 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.
 
Purav Gandhi
Greenhorn
Posts: 21
  • Mark post as helpful
  • send pies
  • 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.
 
Ulf Dittmer
Rancher
Posts: 42970
73
  • Mark post as helpful
  • send pies
  • 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
  • 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: 42970
73
  • Mark post as helpful
  • send pies
  • 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.
 
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!