編輯

共用方式為


_Worksheet.XmlMapQuery(String, Object, Object) Method

Definition

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

public Microsoft.Office.Interop.Excel.Range XmlMapQuery (string XPath, object SelectionNamespaces, object Map);
Public Function XmlMapQuery (XPath As String, Optional SelectionNamespaces As Object, Optional Map As Object) As Range

Parameters

XPath
String

Required Object. The XPath to query for.

SelectionNamespaces
Object

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

Map
Object

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

Returns

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(String, Object, Object) method, the XmlMapQuery method returns the entire column of an XML list, including the header row and the Insert row.

Applies to