Worksheet.XmlMapQuery(String, Object, Object) Method

Reference

Definition

Namespace:: Microsoft.Office.Tools.Excel

Assemblies:: Microsoft.Office.Tools.Excel.dll, Microsoft.Office.Tools.Excel.v4.0.Utilities.dll

Important

Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.

Gets a Range object that represents the cells mapped to a particular XPath. Gets null if the specified XPath has not been mapped to the worksheet.

public Microsoft.Office.Interop.Excel.Range XmlMapQuery (string XPath, object SelectionNamespaces, object Map);

abstract member XmlMapQuery : string * obj * obj -> Microsoft.Office.Interop.Excel.Range

Public Function XmlMapQuery (XPath As String, Optional SelectionNamespaces As Object, Optional Map As Object) As Range

Parameters

XPath: String

The XPath to query for.

SelectionNamespaces: Object

A space-delimited string that contains the namespaces referenced in the XPath parameter. A run-time error is generated if one of the specified namespaces cannot be resolved.

Map: Object

An XmlMap. Specify an XML map if you want to query for the XPath within a specific map.

Returns

Range

A Range object that represents the cells mapped to a particular XPath; null if the specified XPath has not been mapped to the worksheet.

Remarks

XML features, except for saving files in the XML Spreadsheet format, are available only in Microsoft Office Professional Edition 2003 and Microsoft Office Excel 2003.

Unlike the XmlDataQuery method, the XmlMapQuery method returns the entire column of an XML list, including the header row and the Insert row.

Optional Parameters

For information on optional parameters, see Optional Parameters in Office Solutions.

Applies to