Workbook.CustomXmlParts Property

Provides access to a workbook’s collection of custom XML parts.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this property in production code.

Namespace: DevExpress.Spreadsheet

Assembly: DevExpress.Docs.v23.2.dll

NuGet Package: DevExpress.Document.Processor

Declaration

C#

public CustomXmlPartCollection CustomXmlParts { get; }

VB.NET

Public ReadOnly Property CustomXmlParts As CustomXmlPartCollection

Property Value

Type	Description
CustomXmlPartCollection	A collection of custom XML parts.

Remarks

You can embed arbitrary XML data (called custom XML parts) in a workbook. Custom XML parts are included in the document structure but are not visible in the document.

The image below shows the structure of an XLSX file with three custom XML parts (item1, item2, and item3).

The following spreadsheet file formats support custom XML parts:

• XLSX;
• XLSM;
• XLTX;
• XLTM;
• XLSB;
• XLS;
• XLT.

The Workbook.CustomXmlParts property provides access to the CustomXmlPartCollection collection that stores custom XML parts. Use the collection’s members to insert, obtain, modify, or remove custom XML parts.

The example below shows how to add custom XML parts to a workbook.

View Example

CustomXmlPartActions.cs

using DevExpress.Spreadsheet;
using System.Xml;
// ...

using (Workbook workbook = new Workbook())
{
   workbook.Worksheets[0].Cells["A1"].Value = "This workbook contains custom XML parts.";

   // Add an empty custom XML part.
   ICustomXmlPart xmlItem = workbook.CustomXmlParts.Add();
   // Populate the XML part with content.
   XmlElement elem = xmlItem.CustomXmlPartDocument.CreateElement("Person");
   elem.InnerText = "Stephen Edwards";
   xmlItem.CustomXmlPartDocument.AppendChild(elem);

   // Use a string to specify the content for a custom XML part.
   string xmlString = @"<?xml version=""1.0"" encoding=""UTF-8""?>
                           <whitepaper>
                              <contact>
                                 <firstname>Roger</firstname>
                                 <lastname>Edwards</lastname>
                                 <phone>832-433-0025</phone>
                                 <address>1657 Wines Lane Houston, TX 77099</address>
                              </contact>
                              <date>2016-05-18</date>
                           </whitepaper>";
   workbook.CustomXmlParts.Insert(1, xmlString);

   // Add a custom XML part from a file.
   XmlDocument xmlDoc = new XmlDocument();
   xmlDoc.Load("Documents\\fishes.xml");
   workbook.CustomXmlParts.Add(xmlDoc);
   workbook.SaveDocument("Documents\\CustomXmlTestDoc.xlsx", DocumentFormat.Xlsx);
}

CustomXmlPartActions.vb

Imports DevExpress.Spreadsheet
Imports System.Xml
' ...

Using workbook As New Workbook()
   workbook.Worksheets(0).Cells("A1").Value = "This workbook contains custom XML parts."

   ' Add an empty custom XML part.
   Dim xmlItem As ICustomXmlPart = workbook.CustomXmlParts.Add()
   ' Populate the XML part with content.
   Dim elem As XmlElement = xmlItem.CustomXmlPartDocument.CreateElement("Person")
   elem.InnerText = "Stephen Edwards"
   xmlItem.CustomXmlPartDocument.AppendChild(elem)

   ' Use a string to specify the content for a custom XML part.
   Dim xmlString As String = "<?xml version=""1.0"" encoding=""UTF-8""?>
                           <whitepaper>
                              <contact>
                                 <firstname>Roger</firstname>
                                 <lastname>Edwards</lastname>
                                 <phone>832-433-0025</phone>
                                 <address>1657 Wines Lane Houston, TX 77099</address>
                              </contact>
                              <date>2016-05-18</date>
                           </whitepaper>"
   workbook.CustomXmlParts.Insert(1, xmlString)

   ' Add a custom XML part from a file.
   Dim xmlDoc As New XmlDocument()
   xmlDoc.Load("Documents\fishes.xml")
   workbook.CustomXmlParts.Add(xmlDoc)
   workbook.SaveDocument("Documents\CustomXmlTestDoc.xlsx", DocumentFormat.Xlsx)
End Using

Implements

CustomXmlParts