Import XML to Excel workbook
Contents
[
Hide
]
Aspose.Cells allows you to import the XML map inside the workbook using the Workbook.ImportXml() method. You can import XML Map using the Microsoft Excel with the following steps
- Select 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 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 as shown in this screenshot.
![]() |
---|
Advance 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