bytes.com/topic/c-sharp/answers/757466-c-app-reading-modifying-ms-office-document-meta-data

    
1. object GetWordDocumentPropertyValue(Word.Document document, string propertyName)

    
2. {

    
3.   object builtInProperties = document.BuiltInDocumentProperties;

    
4.   Type builtInPropertiesType = builtInProperties.GetType();

    
5.   object property = builtInPropertiesType.InvokeMember("Item", BindingFlags.GetProperty, null, builtInProperties, new object[] { propertyName });

    
6.   Type propertyType = property.GetType();

    
7.   object propertyValue = propertyType.InvokeMember("Value", BindingFlags.GetProperty, null, property, new object[] { });

    
8.   return propertyValue;

    
9. }

    
10.  

    
11. object GetExcelWorkbookPropertyValue(Excel.Workbook workbook, string propertyName)

    
12. {

    
13.   object builtInProperties = workbook.BuiltinDocumentProperties;

    
14.   Type builtInPropertiesType = builtInProperties.GetType();

    
15.   object property = builtInPropertiesType.InvokeMember("Item", BindingFlags.GetProperty, null, builtInProperties, new object[] { propertyName });

    
16.   Type propertyType = property.GetType();

    
17.   object propertyValue = propertyType.InvokeMember("Value", BindingFlags.GetProperty, null, property, new object[] { });

    
18.   return propertyValue;

    
19. }

    
20.  

    
21. object GetPowerPointPresentationPropertyValue(PowerPoint.Presentation presentation, string propertyName)

    
22. {

    
23.   object builtInProperties = presentation.BuiltInDocumentProperties;

    
24.   Type builtInPropertiesType = builtInProperties.GetType();

    
25.   object property = builtInPropertiesType.InvokeMember("Item", BindingFlags.GetProperty, null, builtInProperties, new object[] { propertyName });

    
26.   Type propertyType = property.GetType();

    
27.   object propertyValue = propertyType.InvokeMember("Value", BindingFlags.GetProperty, null, property, new object[] { });

    
28.   return propertyValue;

    
29. }

    
30.  

    
31. void SetWordDocumentPropertyValue(Word.Document document, string propertyName, string propertyValue)

    
32. {

    
33.   object builtInProperties = document.BuiltInDocumentProperties;

    
34.   Type builtInPropertiesType = builtInProperties.GetType();

    
35.   object property = builtInPropertiesType.InvokeMember("Item", System.Reflection.BindingFlags.GetProperty, null, builtInProperties, new object[] { propertyName });

    
36.   Type propertyType = property.GetType();

    
37.   propertyType.InvokeMember("Value", BindingFlags.SetProperty, null, property, new object[] { propertyValue });

    
38.   document.UpdateSummaryProperties();

    
39.   document.Save();

    
40. }

    
41.  

    
42. void SetExcelWorkbookPropertyValue(Excel.Workbook workbook, string propertyName, string propertyValue)

    
43. {

    
44.   object builtInProperties = workbook.BuiltinDocumentProperties;

    
45.   Type builtInPropertiesType = builtInProperties.GetType();

    
46.   object property = builtInPropertiesType.InvokeMember("Item", System.Reflection.BindingFlags.GetProperty, null, builtInProperties, new object[] { propertyName });

    
47.   Type propertyType = property.GetType();

    
48.   propertyType.InvokeMember("Value", BindingFlags.SetProperty, null, property, new object[] { propertyValue });

    
49.   workbook.Save();

    
50. }

    
51.  

    
52. void SetPowerPointPresentationPropertyValue(PowerPoint.Presentation presentation, string propertyName, string propertyValue)

    
53. {

    
54.   object builtInProperties = presentation.BuiltInDocumentProperties;

    
55.   Type builtInPropertiesType = builtInProperties.GetType();

    
56.   object property = builtInPropertiesType.InvokeMember("Item", System.Reflection.BindingFlags.GetProperty, null, builtInProperties, new object[] { propertyName });

    
57.   Type propertyType = property.GetType();

    
58.   propertyType.InvokeMember("Value", BindingFlags.SetProperty, null, property, new object[] { propertyValue });

    
59.   presentation.Save();

    
60. }

 

Understanding the Word Object Model from a .NET Developer's Perspective

msdn.microsoft.com/en-us/library/aa192495(office.11).aspx

2007 Microsoft Office System Update: Redistributable Primary Interop Assemblies

www.microsoft.com/downloads/details.aspx

PIA for office 2003:

www.microsoft.com/downloads/details.aspx

msdn.microsoft.com/en-us/library/15s06t57.aspx

www.java2s.com/Code/CSharp/Office/ModifyWordDocumentProperties.htm

using System;

using System.Windows.Forms;

using System.Runtime.InteropServices;

using System.Reflection;

using Word;





namespace Client.Chapter_19___Office_Integration

{

  public class ModifyDocumentProperties

  {

    [STAThread]

    static void Main(string[] args)

    {

      object Missing = Missing.Value;

      object BuiltInProps;

      object CustomProps;

      Word._Document Doc;

      Word.ApplicationClass MyWord = new Word.ApplicationClass();



      MyWord.Visible = true;

      Doc = MyWord.Documents.Add(ref Missing, ref Missing, ref Missing, ref Missing);

      BuiltInProps = Doc.BuiltInDocumentProperties;



      Type TypeBuiltingProp = BuiltInProps.GetType();



      //Setting abuilt-in property

      string Prop = "Author";

      string PropValue;

      object AuthorProp = TypeBuiltingProp.InvokeMember("item", BindingFlags.Default | BindingFlags.GetProperty, null, BuiltInProps, new Object[] { Prop });

      Type TypeAuthorProp = AuthorProp.GetType();



      PropValue = TypeAuthorProp.InvokeMember("Value", BindingFlags.Default | BindingFlags.GetProperty, null, AuthorProp, new Object[]{}).ToString();

      System.Windows.Forms.Application.Run();

    }

  }



}

 

Considerations for server-side Automation of Office

support.microsoft.com/default.aspx

The Dsofile.dll files lets you edit Office document properties when you do not have Office installed

support.microsoft.com/kb/224351

blogs.msdn.com/vsod/archive/2009/06/30/word-2003-excel-2003-vsto-customization-added-using-serverdocument-addcustomization-method-does-not-add-customization-if-your-document-contained-an-embedded-vsto-customized-document-workbook.aspx

 

 

-- 27/08/2009 12:29:02: post edited by sergey.

Microsoft Developer Support OLE File Property Reader 2.1 Sample (KB 224351)

www.microsoft.com/downloads/details.aspx