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….

Advertisements

Leave a Reply

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

WordPress.com Logo

You are commenting using your WordPress.com 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 )

Google+ photo

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

Connecting to %s