.NET Framework 4.5.2+
.NET Framework 4.5.2+
.NET Standard 2.0+
Row

IWorkbook.CustomXmlParts Property

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

Namespace: DevExpress.Spreadsheet

Assembly: DevExpress.Spreadsheet.v21.2.Core.dll

Declaration

CustomXmlPartCollection CustomXmlParts { get; }

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

Workbook_CustomXmlParts

The following spreadsheet file formats support custom XML parts:

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

The IWorkbook.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.

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

IWorkbook workbook = spreadsheetControl.Document;
workbook.BeginUpdate();
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.EndUpdate();

workbook.SaveDocument("Documents\\CustomXmlTestDoc.xlsx", DocumentFormat.Xlsx);

The following code snippets (auto-collected from DevExpress Examples) contain references to the CustomXmlParts property.

Note

The algorithm used to collect these code examples remains a work in progress. Accordingly, the links and snippets below may produce inaccurate results. If you encounter an issue with code examples below, please use the feedback form on this page to report the issue.

See Also