访问Excel自定义文档属性编程 [英] Accessing Excel Custom Document Properties programatically
问题描述
我想自定义属性添加到我已经编程创建工作簿。我对获取和设置属性到位的方法,但问题是该工作簿为CustomDocumentProperties属性返回null。我无法弄清楚如何初始化这个属性,这样我可以从工作簿中添加和检索性能。 Microsoft.Office.Core.DocumentProperties是一个接口,所以我不能去,然后执行以下
I'm trying to add custom properties to a workbook I have created programatically. I have a method in place for getting and setting properties, but the problem is the workbook is returning null for the CustomDocumentProperties property. I cannot figure out how to initialize this property so that I can add and retrieve properties from the workbook. Microsoft.Office.Core.DocumentProperties is an interface, so I cant go and do the following
if(workbook.CustomDocumentProperties == null)
workbook.CustomDocumentProperties = new DocumentProperties;
下面是code我要获取和设置属性:
Here is the code I have to get and set the properties:
private object GetDocumentProperty(string propertyName, MsoDocProperties type)
{
object returnVal = null;
Microsoft.Office.Core.DocumentProperties properties;
properties = (Microsoft.Office.Core.DocumentProperties)workBk.CustomDocumentProperties;
foreach (Microsoft.Office.Core.DocumentProperty property in properties)
{
if (property.Name == propertyName && property.Type == type)
{
returnVal = property.Value;
}
DisposeComObject(property);
}
DisposeComObject(properties);
return returnVal;
}
protected void SetDocumentProperty(string propertyName, string propertyValue)
{
DocumentProperties properties;
properties = workBk.CustomDocumentProperties as DocumentProperties;
bool propertyExists = false;
foreach (DocumentProperty prop in properties)
{
if (prop.Name == propertyName)
{
prop.Value = propertyValue;
propertyExists = true;
}
DisposeComObject(prop);
if(propertyExists) break;
}
if (!propertyExists)
{
properties.Add(propertyName, false, MsoDocProperties.msoPropertyTypeString, propertyValue, Type.Missing);
}
DisposeComObject(propertyExists);
}
行
性能= workBk.CustomDocumentProperties为DocumentProperties;
总是设置属性为null。
The line properties = workBk.CustomDocumentProperties as DocumentProperties; always set properties to null.
这是使用Microsoft.Office.Core v12.0.0.0和Microsoft.Office.Interop.Excell v12.0.0.0(Office 2007中)
This is using Microsoft.Office.Core v12.0.0.0 and Microsoft.Office.Interop.Excell v12.0.0.0 (Office 2007)
推荐答案
我看了看我自己的code和可以看到,我使用后期绑定访问属性。我不记得为什么,但我会在情况下,它可以帮助张贴一些code。
I looked at my own code and can see that I access the properties using late binding. I can't remember why, but I'll post some code in case it helps.
object properties = workBk.GetType().InvokeMember("CustomDocumentProperties", BindingFlags.Default | BindingFlags.GetProperty, null, workBk, null);
object property = properties.GetType().InvokeMember("Item", BindingFlags.Default | BindingFlags.GetProperty, null, properties, new object[] { propertyIndex });
object propertyValue = property.GetType().InvokeMember("Value", BindingFlags.Default | BindingFlags.GetProperty, null, propertyWrapper.Object, null);
修改:啊,我现在还记得为什么。 : - )
EDIT: ah, now I remember why. :-)
编辑2 :Jimbojones的答案 - 使用动态关键字 - 是一个更好的解决方案。
EDIT 2: Jimbojones' answer - to use the dynamic keyword - is a better solution.
这篇关于访问Excel自定义文档属性编程的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!