Performance issue with accessing Microsoft.Office.Core.DocumentPro
 

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!