Problem with JExcel API

[SupriyaPS PS]

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]

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]

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]

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]

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]

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.