ASP.NET - Gembox ExcelFile .LoadXls() or .LoadXlsx() method error

Asked By sruthi m on 30-Jun-14 07:14 AM
Could you please suggest on below issue ?

   Excel File ef = new ExcelFile();
   ef.LoadXlsx(strFilePath, XlsxOptions.PreserveMakeCopy);


When i trying to load Excel file 19MB  and it contains 22 k rows , throwing "System.Out.Memory Exception"
Robbe Morris replied to sruthi m on 03-Jul-14 12:17 PM
Can you open this file in Microsoft Excel?  I'm wondering if the file contains circular calculation references that might be blowing this up for you.  Opening it in Excel would give you clues if this, or something similar, were the issue.