Hi Support,

We are using WPF Infragistics 2014.2 and facing performance issue with Infragistics Excel engine to load the Excel (.xls/.xlsx) file. The “Workbook.Load” method takes lot of time to load the file and resulting in either freezing the application or raising “OutOfMemoryException”. The excel file we are trying to load has 9 billion rows and 15 columns (no.of rows and columns may vary on data). We also tried loading this file on the machine with higher configuration (8 GB RAM), however still loading the workbook takes time and result in “OutOfMemoryException”.

  Following is the code snippet we have used to load the workbook and read its sheet names.

 Object _workBookOrCSV = Infragistics.Documents.Excel.Workbook.Load(workbookPath);

 //cboWorksheet is ComboBox here

for (int i = 0; i < ((Workbook)_workBookOrCSV).Worksheets.Count; i++)

{

    cboWorksheet.Items.Add(((Workbook)_workBookOrCSV).Worksheets[i].Name);

}

 Can you please let us know whether Infragistics Excel engine has any limit on file size to be loaded in an object at a time and also any other way to load the excel file?