Query Cell Areas Mapped to XML Map Path using Worksheet.XmlMapQuery method

Possible Usage Scenarios

You can query cell areas mapped to the XML map path with Aspose.Cells for Python via .NET using the Worksheet.xml_map_query() method. If the path exists, it will return the list of cell areas related to that path inside XML map. The first parameter of the Worksheet.xml_map_query() method specifies the XML element path and the second parameter specifies an XML map you want to query.

Query Cell Areas Mapped to XML Map Path using Worksheet.XmlMapQuery method

The following screenshot shows the Microsoft Excel displaying XML Map inside the sample Excel file used in the code. The code queries the XML map two times and prints the list of cell areas returned by the Worksheet.xml_map_query() method on the console as shown below.

Sample Code

from aspose.cells import Workbook

#  For complete examples and data files, please go to https:# github.com/aspose-cells/Aspose.Cells-for-.NET
# Load sample Excel file having Xml Map
wb = Workbook("sampleXmlMapQuery.xlsx")
# Access first XML Map
xmap = wb.worksheets.xml_maps[0]
# Access first worksheet
ws = wb.worksheets[0]
# Query Xml Map from Path - /MiscData
print("Query Xml Map from Path - /MiscData")
ret = ws.xml_map_query("/MiscData", xmap)
# Print returned ArrayList values
for i in range(len(ret)):
    print(ret[i])
print("")
# Query Xml Map from Path - /MiscData/row/Color
print("Query Xml Map from Path - /MiscData/row/Color")
ret = ws.xml_map_query("/MiscData/row/Color", xmap)
# Print returned ArrayList values
for i in range(len(ret)):
    print(ret[i])

Console Output

Query Xml Map from Path - /MiscData

Aspose.Cells.CellArea(A1:A8)[0,0,7,0]

Aspose.Cells.CellArea(B1:B8)[0,1,7,1]

Aspose.Cells.CellArea(C1:C8)[0,2,7,2]

Aspose.Cells.CellArea(D1:D8)[0,3,7,3]

Aspose.Cells.CellArea(E1:E8)[0,4,7,4]

Query Xml Map from Path - /MiscData/row/Color

Aspose.Cells.CellArea(D1:D8)[0,3,7,3]

Get XML path from List Object/Table

XML data can be imported to worksheets. Sometimes XML path is required from the ListObjects of the worksheet. This feature is available in Excel by using an expression like Sheet1.ListObjects(1).XmlMap.DataBinding. The same feature is available in Aspose.Cells for Python via .NET by calling ListObject.xml_map.data_binding.url.  The following example demonstrates this feature. Template file and other source files can be downloaded from the following links:

1. XML Data.xlsx
2. Country List.xml
3. Food List.xml

from aspose.cells import Workbook

#  For complete examples and data files, please go to https:# github.com/aspose-cells/Aspose.Cells-for-.NET
#  Load XLSX file containing data from XML file
workbook = Workbook("XML Data.xlsx")
#  Access the first worksheet
ws = workbook.worksheets[0]
#  Access ListObject from the first sheet
listObject = ws.list_objects[0]
#  Get the url of the list object's xml map data binding
url = listObject.xml_map.data_binding.url
#  Display XML file name
print(url)