Your Privacy Matters: We use our own and third-party cookies to improve your experience on our website. By continuing to use the website we understand that you accept their use. Cookie Policy
1355
Workbook.Load takes around 5 min for reading a 2007 Excel file with 500 rows
posted

Hi,

1 of our user file  had bunch of pivot tables (in multiple worksheets) in this workbook and some standard dataset in worksheets and formula referring to other worksheets. I tried to import this excel file using

Workbook wbExceldata = Workbook.Load(fileName);

and it takes 3 to 4 min for executing the Load command  for loading empty workbook with 1 blank sheet  (I deleted all other worksheets).

Even after removing all worksheets still it is 600 KB. it seems to holding it in memory i guess.It works for other excel files and am guessing something weird in this workbook.

Can you please help me to figure out why this file takes long time to load.

 

Thanks,

Valliappan