Java code to control excel sheet report

[Bharath Sundar]

Hello,

I am writing a java code which generates the excel sheet report, using jxl.jar to create the excel report.. But in excel sheet the maximum limit of rows is 65536, if the report has to be generated more than 65536, the java code throws the exception.

Let me know is there any way to handle the exception so that if the maximum row count is reached, it should automatically start writing in the next sheet of the excel file. Please provide me any code snippet of the same.



Regards,
Bharath.S

[Ulf Dittmer]

Keeping track of how many rows you've created, and then creating a new sheet once you hit the max shouldn't be too hard, should it? What problem are you facing specifically when implementing that?

[Bharath Sundar]

Hi,

Thanks for the reply. This is my first real time Java project. So I dont know how to move to next sheet through code when the maximum count is reached.

I am able to trap the maximum count. but suggest me how can I move to next sheet through java code.

Regards,
Bharath.S