File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
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
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: 39548
    
  27
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 - updated with new look and Ping home screen widget
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
accessing excel file from java
can we export the data from jsp page to a excel sheet with out a database hit
Excel Reading using java
Java Excel API - Help[ Needed
How to increase excel row count