Prev: Oh look...the forum is not working again. NOT SURPRISES!!!!!
Next: Adding a dropdownlist programmatically to a ASP.NET webpage
From: Raghvendra on 21 Jan 2010 10:10
Hi,

I have a Excel COM addin which reads the CustomDocumentProperties section of
a workbook.

This is how I access a particular entry from the CustomDocumentProperties
section

DocumentProperties docProperties = (DocumentProperties)
xlWorkbook.CustomDocumentProperties;

docProperty = docProperties[propName];

The problem is when the CustomDocumentProperties contain more than 8000
entries, the performance of this code is really bad. I have ran CPU profiler
and it showed that the following line takes more than a minute.

docProperty = docProperties[propName];
Does anyone know how to improve the performance of accessing
DocumentProperties?

Thanks!
 | 
Pages: 1
Prev: Oh look...the forum is not working again. NOT SURPRISES!!!!!
Next: Adding a dropdownlist programmatically to a ASP.NET webpage