Read custom Properties of an Excel Workbook

You can read the Custom properties of any office document (below is an example for Excel workbook)

using System.Reflection;
using System;

object GetExcelWorkbookPropertyValue(Microsoft.Office.Interop.Excel.Workbook workbook, string propertyName)
object builtInProperties =workbook.CustomDocumentProperties;
Type builtInPropertiesType = builtInProperties.GetType();

object property = builtInPropertiesType.InvokeMember(“Item”, BindingFlags.GetProperty, null, builtInProperties, new object[] { propertyName });
Type propertyType = property.GetType();
object propertyValue = propertyType.InvokeMember(“Value”, BindingFlags.GetProperty, null, property, new object[] { }); return propertyValue;


Hope this will help you….


Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s