wood burning stoves*
The moose likes Other Open Source Projects and the fly likes generate large XLS file using java 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 "generate large XLS file using java" Watch "generate large XLS file using java" New topic
Author

generate large XLS file using java

rocker Joshi
Greenhorn

Joined: Dec 23, 2011
Posts: 1
I need to generate a XLS-2003 file which may contain 65K rows and 230 columns using a simple XLS template file. Data will be picked up from standard tab seperated data file.
After generating Excel excel , I want to format that excel file and run some macros on that.

I tried LightCells API from Aspose , HSSF POI 3.0.7, JExcel.

But it is throwing :- java.lang.OutOfMemoryError: Java heap space
Is there any way to achieve this ?
Tim Moores
Rancher

Joined: Sep 21, 2011
Posts: 2408
POI needs a lot of memory, particularly for large spreadsheets. Try giving the JVM more memory (maybe 512MB or 1GB). (And, of course, update to a newer version of POI - 3.0 has been obsolete for years.)
Shahzad Latif
Greenhorn

Joined: Apr 28, 2011
Posts: 28
Do all the components throw this exception? Looks like you either have a very large Excel file or low heap space allocated. As suggested earlier, please try to increase the heap space. Moreover, if you still find the issue with Aspose.Cells for Java, you may contact our support team via Aspose.Cells forum; we will have to investigate whether it is the size of the PDF file or particular structure which is causing the problem.


Developer Evangelist @ Aspose. I love to explore and learn new technologies and help other developers along the way.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: generate large XLS file using java
 
Similar Threads
Export data from Jsp to Excel taking more load time
Show in the browser one excel file
POI HSSF - Excel question
Show in the browser one excel file
Getting number of rows and column from Excel, using JXL library