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.

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.