Java heap space exception while reading large XLS/XLSX file

CloverDX Platform
1

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

2

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.