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
Hello Villiappan,
This issue has been fixed in the latest service release for NetAdvantage for Windows Forms 2011 vol1 and 2011 vol2.
If you have any other questions please feel free to let us know.
Hi Danko,
I havn't got a chance to test in the latest release. We are planning to upgrade from v10.2 to the latest release .can you please let me know which is the latest release and is this fix included in th latest release?
Hello Valliappan,
In our latest service release we have improved the performance when you are having similar scenarios like the mentioned one.
Please feel free to let us know if you have any other questions with this matter.
Just to let you know that I have created the following case for you : CAS-79799-RMQVXT
The cases will be linked to an internal work item for improving the load time when there are any NamedReferences in the file.
There is a way to remove the NamedReferences and the styles in your file programatically, but you will have to wait the intial loading time and once the workbook is loaded you could do something like the following to remove them (in your case there are 35901 styles and 71 named references):
Workbook wb = Workbook.Load("..\\..\\SomeExcelFile.xlsx");wb.NamedReferences.Clear();wb.Styles.Clear();
If you have any other questions please feel free to let me know.
Thanks Danko. So, if we have excel workbook with pivot tables and styles, it will take more time for loading. is that true? .i tested with the file u sent , loading is faster. Is there any other way where i can programtically remove these references and styles before trying to import data ( The worksheet i want to import does not hv any references) from this file?