• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Liutauras Vilda
  • Paul Clapham
Sheriffs:
  • paul wheaton
  • Tim Cooke
  • Henry Wong
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Piet Souris
Bartenders:
  • Mike London

generate large XLS file using java

 
Greenhorn
Posts: 1
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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 ?
 
Bartender
Posts: 7488
171
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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.)
 
Greenhorn
Posts: 28
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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.

 
reply
    Bookmark Topic Watch Topic
  • New Topic