Link Cells to XML Map Elements

Possible Usage Scenarios

You can link your cells to XML Map elements using Aspose.Cells. Please use the Cells.LinkToXmlMap() method for this purpose.

The following sample code loads the source excel file which contains XML Map and then links cells A1, B2, C3, D4, E5, and F6 to XML Map elements FIELD1, FIELD2, FIELD4, FIELD5, FIELD7, and FIELD8 respectively and then saves the workbook in output excel file.

If you open the output excel file and click the Developer > Source button, you will see the cells are linked with XML Map elements and they will also be highlighted by Microsoft Excel as shown in this image.

Find the Root Element Name of XML Map Query Cell Areas Mapped to XML Map Path using Worksheet.XmlMapQuery method