Use Custom XML Parts in Aspose.Cells

Using Custom XML Parts in Aspose.Cells

Custom XML Parts are the XML data that is stored by different applications like SharePoint etc. inside the excel file. This data is consumed by different applications that need it. Microsoft Excel does not make use of this data so there is no GUI to add it. You can view this data by changing the extension of .xlsx into .zip and then by opening it using WinZip. You can also open the ZIP file using any 3rd part Windows zip utility such as WinRAR or WinZip etc. The data is present inside the customXml folder.

You can add custom XML parts using Aspose.Cells via the Workbook.ContentTypeProperties.Add() method.

The following sample code makes use of Workbook.ContentTypeProperties.Add() method and adds the Book Catalog XML and its name is BookStore. The following image shows the result of this code. As you can see Book Catalog XML is added inside the BookStore node which is the name of this property.

C# code to use custom XML parts

// For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET
// The path to the documents directory
string dataDir = RunExamples.GetDataDir(System.Reflection.MethodBase.GetCurrentMethod().DeclaringType);

// The sample XML that will be injected to Workbook
string booksXML = @"<catalog>
   <book>
      <title>Complete C#</title>
      <price>44</price>
   </book>
   <book>
      <title>Complete Java</title>
      <price>76</price>
   </book>
   <book>
      <title>Complete SharePoint</title>
      <price>55</price>
   </book>
   <book>
      <title>Complete PHP</title>
      <price>63</price>
   </book>
   <book>
      <title>Complete VB.NET</title>
      <price>72</price>
   </book>
</catalog>";
            
// Create an instance of Workbook class
Workbook workbook = new Workbook();

// Add Custom XML Part to ContentTypePropertyCollection
workbook.ContentTypeProperties.Add("BookStore", booksXML);

// Save the resultant spreadsheet
workbook.Save(dataDir + "output.xlsx");

Related Article

• Adding Custom Properties visible inside Document Information Panel