How to: Add Custom XML Parts to Documents by Using VSTO Add-Ins

 

You can store XML data in the following types of documents by creating a custom XML part in a VSTO Add-in:

  • A Microsoft Office Excel workbook.

  • A Microsoft Office Word document.

  • A Microsoft Office PowerPoint presentation.

For more information, see Custom XML Parts Overview.

Applies to: The information in this topic applies to application-level projects for Excel, PowerPoint, and Word. For more information, see Features Available by Office Application and Project Type.

To add a custom XML part to an Excel workbook

  1. Add a new CustomXMLPart object to the CustomXMLParts collection in the workbook. The CustomXMLPart contains the XML string that you want to store in the workbook.

    The following code example adds a custom XML part to a specified workbook.

    C#
    VB
    C++
    Copy
    No code example is currently available or this language may not be supported.

  2. Add the AddCustomXmlPartToWorkbook method to the ThisAddIn class in an VSTO Add-in project for Excel.

  3. Call the method from other code in your project. For example, to create the custom XML part when the user opens a workbook, call the method from an event handler for the WorkbookOpen event.

To add a custom XML part to a Word document

  1. Add a new CustomXMLPart object to the P:Microsoft.Office.Interop.Word._Document.CustomXMLParts collection in the document. The CustomXMLPart contains the XML string that you want to store in the document.

    The following code example adds a custom XML part to a specified document.

    C#
    VB
    C++
    Copy
    No code example is currently available or this language may not be supported.

  2. Add the AddCustomXmlPartToDocument method to the ThisAddIn class in an VSTO Add-in project for Word.

  3. Call the method from other code in your project. For example, to create the custom XML part when the user opens a document, call the method from an event handler for the E:Microsoft.Office.Interop.Word.ApplicationEvents4_Event.DocumentOpen event.

To add a custom XML part to a PowerPoint presentation

  1. Add a new CustomXMLPart object to the P:Microsoft.Office.Interop.PowerPoint._Presentation.CustomXMLParts collection in the presentation. The CustomXMLPart contains the XML string that you want to store in the presentation.

    The following code example adds a custom XML part to a specified presentation.

    C#
    VB
    C++
    Copy
    No code example is currently available or this language may not be supported.

  2. Add the AddCustomXmlPartToPresentation method to the ThisAddIn class in an VSTO Add-in project for PowerPoint.

  3. Call the method from other code in your project. For example, to create the custom XML part when the user opens a presentation, call the method from an event handler for the E:Microsoft.Office.Interop.PowerPoint.EApplication_Event.AfterPresentationOpen event.

For simplicity, this example uses an XML string that is defined as a local variable in the method. Typically, you should obtain the XML from an external source, such as a file or a database.

Custom XML Parts Overview
How to: Add Custom XML Parts to Document-Level Customizations

Show: