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.