Java heap space exception while reading large XLS/XLSX file

pgargdd

• November 29, 2010 00:00

• Answered

Follow

Hi,

I need to parse a large XLS/XLSX file and I am using XLSDataReader but it is giving out of memory exception as file size increases by 8 MB.
Please let me know if there is any component available to read large XLS files without increasing jvm size.

Thanks
Pushpendra

• 

  avackova

  • November 29, 2010 14:05

  0

  Comment actions Permalink

  Hello Pushpendra,
  XLSDataReader needs to load all data to memory as it uses JExcel (xls) or POI (xlsx) libraries for getting the data.
  Another component you can try is DBInputTable - there are some projects on the internet, that provide a xls-jdbc bridge for reading data from xls files.

Please sign in to leave a comment.