Hi All,
As per business functionality we need to read multiple excel files(both .xls and .xlsx format) at different locations in a multi
thread environment. Each thread is responsible for reading a file. In order to
test the performance, we have created 2 file sets in both .xls and .xlsx formats. One file set has just 20 row data while other file set contains 300,000 row data. We are able successfully read both files in .xls formats and load data into the table. Even for 20 row data .xlsx file, our source code is working fine.
But when the execution flow starts reading .xlsx file, application server is terminated abruptly. When I started tracing down the issue, I have been facing a strange issue while creating
XSSFWorkbook instance.Refer the code snippet below:
Output :
Process XLSX file EXCEL_300K.xlsx start.
Process XLSX file EXCEL.xlsx start.
Created OPCPackage instance.
Created OPCPackage instance.
Created XSSFWorkbook instance.
Created SXSSFWorkbook instance.
Process XLSX file EXCEL.xlsx end.
For larger file set the execution hangs at
causing heap space issue. Please do help me to fix this issue.
Thanks in advance.
Thanks,
Sankar.