wood burning stoves 2.0*
The moose likes Other Open Source Projects and the fly likes Java code to control excel sheet report Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Products » Other Open Source Projects
Bookmark "Java code to control excel sheet report" Watch "Java code to control excel sheet report" New topic
Author

Java code to control excel sheet report

Bharath Sundar
Greenhorn

Joined: Feb 19, 2009
Posts: 13
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
Marshal

Joined: Mar 22, 2005
Posts: 41180
    
  45
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?


Ping & DNS - my free Android networking tools app
Bharath Sundar
Greenhorn

Joined: Feb 19, 2009
Posts: 13
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
 
subject: Java code to control excel sheet report
 
Similar Threads
can we export the data from jsp page to a excel sheet with out a database hit
Java Excel API - Help[ Needed
Excel Reading using java
How to increase excel row count
accessing excel file from java