• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Java code to control excel sheet report

 
Bharath Sundar
Greenhorn
Posts: 13
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Rancher
Pie
Posts: 42966
73
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Greenhorn
Posts: 13
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
I agree. Here's the link: http://aspose.com/file-tools
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic