Import XML to Excel workbook

Aspose.Cells allows you to import the XML map into the workbook using the Workbook.ImportXml() method. You can import an XML map using Microsoft Excel with the following steps:

• Select the Developer tab
• Click Import in the XML section and follow the required steps.

You will need to provide your XML data to complete the import. Here is a sample XML data that you can use for testing.

Import XML Map using Microsoft Excel

The following screenshot shows how to import an XML map using Microsoft Excel.

Import XML Map using Aspose.Cells

The following sample code shows how to make use of the Workbook.ImportXml(). It generates the output Excel file (output excel file) as shown in this screenshot.

Advanced topics

• Add XML Map inside the Workbook using XmlMapCollection.Add method
• Export XML Data linked to XML Map inside the Workbook
• Find the Root Element Name of XML Map
• Link Cells to XML Map Elements
• Query Cell Areas Mapped to XML Map Path using Worksheet.XmlMapQuery method