• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

generate large XLS file using java

 
rocker Joshi
Greenhorn
Posts: 1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Bartender
Posts: 2895
46
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 28
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.

 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic