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 Valliappan,
I have tested the original file in my environment and it takes me about 92 seconds to load the workbook.
We will probably be able to improve the performance so I will log this behavior in our internal system.
After removing the NamedReferences and the styles from the mentioned file, it takes less than 1 second to load the workbook.
If you would like to remove the NamedReferences you could go to "Formulas" tab, and under the "Defined Names" Group there is "Name Manager". Once you open it, you would be able to delete all of the references there.
I am attaching the file to this forum thread, so you could test it with the desired number of records, and let me know if you still need any other assistance with this matter.
Hi Danko,
Cool. I did also find that "Named references" in the debugger ( Count as 71) after the file was loaded. I was not sure why it was still retained in memory even after deleting those worksheet references and pivot tables. hoe can i remove this from the excel ?
Reg "Style" property, where is this embedded in the worksheet? how can i view this.?Assuming, If we r removing both these properties and have some data in the workbook , is import faster?
Can u please go ahead and remove those and try with some records?
I have found the reason why this file has this size. After unzipping it, the size gets up to 613KB.
After that if I remove all of the named references it becoms 308KB. I have further investigated that file and it contains kind of "styes" which are actually about 7MB in size, but packed in the excel file they gets about 300KB. If I remove them as well the file goes about 7KB.
Could you please let me know if you need those "styles" or you would like to have just the named references kept inside the file?
Thank you for using Infragistics.
Thanks for that tip on upload. Please find the blank excel workbook attached with this mail.
Hello Villiappan,
Could you please try to attach the zipped file again using the "Insert Media" option from the from the toolbar above the editing area of while you are replying.
If you have any other questions please feel free to ask.