Worksheet.XmlMapQuery

Worksheet.XmlMapQuery method

Query cell areas that mapped/linked to the specific path of xml map.

[Obsolete("Use Worksheet.GetAreasOfXmlMapQuery() method instead.")]
[EditorBrowsable(EditorBrowsableState.Never)]
public ArrayList XmlMapQuery(string path, XmlMap xmlMap)
ParameterTypeDescription
pathStringxml element path
xmlMapXmlMapSpecify an xml map if you want to query for the specific path within a specific map

Return Value

CellArea list that mapped/linked to the specific path of xml map, an empty list is returned if nothing is mapped/linked.

Remarks

NOTE: This method is now obsolete. Instead, please use Worksheet.GetAreasOfXmlMapQuery() method. This property will be removed 12 months later since March 2025. Aspose apologizes for any inconvenience you may have experienced.

Examples

using System;
using System.Collections;
using Aspose.Cells;

namespace AsposeCellsExamples
{
    public class WorksheetMethodXmlMapQueryWithStringXmlMapDemo
    {
        public static void Run()
        {
            // Create a workbook
            Workbook workbook = new Workbook();
            
            // Add a worksheet
            Worksheet worksheet = workbook.Worksheets[0];
            
            // Create a sample XML map
            string xml = @"<?xml version='1.0' encoding='UTF-8'?>
                <ns1:Root xmlns:ns1='http://example.com'>
                    <ns1:Data>
                        <ns1:Item>Value1</ns1:Item>
                    </ns1:Data>
                </ns1:Root>";
            
            // Import XML to create the map
            workbook.ImportXml(xml, "Sheet1", 0, 0);
            
            // Get the XML map
            XmlMap xmlMap = workbook.Worksheets.XmlMaps[0];
            
            // Query the XML map
            ArrayList cellAreas = worksheet.XmlMapQuery("/ns1:Root/ns1:Data/ns1:Item", xmlMap);
            
            // Output results
            if (cellAreas.Count > 0)
            {
                CellArea area = (CellArea)cellAreas[0];
                Console.WriteLine($"Found data at row {area.StartRow}, column {area.StartColumn}");
                Console.WriteLine($"Cell value: {worksheet.Cells[area.StartRow, area.StartColumn].StringValue}");
            }
        }
    }
}

See Also