Hi
When we are trying to read an excel sheet containing around 200000 records it is taking more than 4-5 minutes.
Find below the codeblock that we are using:
LoadOptions loadOptions= new LoadOptions(LoadFormat.Xlsb);
loadOptions.LoadDataOptions.ImportFormula = false;
loadOptions.LoadDataAndFormatting = true;
LightCellsDataHandlerVisitCells lightCellsDataHandler = new LightCellsDataHandlerVisitCells();
loadOptions.LightCellsDataHandler = lightCellsDataHandler;
Workbook wb = new Workbook(stream, loadOptions);
var dt = worksheet.Cells.ExportDataTableAsString
(HeaderRow - 1, 0, worksheet.Cells.MaxDataRow + HeaderRow, worksheet.Cells.MaxDataColumn + 1);
Kindly advice us on what best can be done to optimize this.
Hi,
If you still find the issue with it, kindly create a sample console application (runnable), zip it and post us here to reproduce the issue on our end, we will check it soon. Also provide your template file here.
By the way, if your underlying file is XLSX instead of XLSB file format, how much time it takes then?
Thank you.