Worksheet.XmlMapQuery Method
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.
Syntax
expression.XmlMapQuery(XPath, SelectionNamespaces, Map)
expression A variable that represents a Worksheet object.
Parameters
| Name | Required/Optional | Data Type | Description |
|---|---|---|---|
| XPath | Required | String | The XPath to query for. |
| SelectionNamespaces | Optional | Variant | 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 | Optional | Variant | Specify an XML map if you want to query for the XPath within a specific map. |
Return Value
Range
Remarks
Unlike the XmlDataQuery method, the XmlMapQuery method returns the entire column of an XML list, including the header row.
 Note
|
|---|
| XmlMapQuery allows developers to query for the existence of particular maps. It can not be used to query for a piece of data in a map. For example, it is valid for a mapped range to exist in which the XPath for that range is "/root/People[@Age="23"]/FirstName". An XmlMapQuery call for this XPath will returnreturns the correct range. However, a query for "/root/People[firstname="joe"]" expecting to find "Joe" within the above mapped range will fail because the XPath definitions for the mapped ranges are different. |