XSSFWorkbook is taking too much time to load excel file using InputStream

83 Views Asked by At

When I'm trying to read Excel file using Apache PO XSSFWorkbook, below line is taking more than 20 minutes for loading a 4 MB Excel file.

XSSFWorkbook workbook = new XSSFWorkbook(blob.getBinaryStream()); 

I tried with workbook.create() streaming method as well, but result is the same. Kindly suggest and advise on below issue

I tried all the possible approaches of Excel file read like SXSSFWorkbook, Workbook, XSSFReader), but not getting fruitful results. My expectation is program should read file as fast as possible.

0

There are 0 best solutions below