访问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屋！