View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Raghvendra Raghvendra is offline
external usenet poster
 
Posts: 1
Default 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!