XmlDataQuery Method [Excel 2003 VBA Language Reference]

Note  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.

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, or if the mapped range is empty.

expression**.XmlDataQuery(XPath**, SelectionNamespaces, Map)

expression Required. An expression that returns a Worksheet object.

XPath  Required String. The XPath to query for.

SelectionNamespaces  Optional String. 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 XmlMap. Specify an XML map if you want to query for the XPath within a specific map.

Note  The XmlDataQuery method allows you to query for the existence of particular map data. 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 XmlDataQuery query for this XPath location path will returnreturns the correct range. However, a query for "/root/People[FirstName="Joe"]" hoping to find "Joe" within the above mapped range will fail because the XPath definitions for the mapped ranges are different.

Remarks

If the XPath exists within a column in an XML list, the Range object returned does not include the header row or the Insert row.

This method returns Nothing if the XPath location path is not mapped into the grid. Thus, a return of Nothing doesn't necessarily mean that the map doesn't exist. It could mean that there is currently no data range available at the specified XPath location. You can use XmlMapQuery Method to check for the existence of a mapped XPath.

Applies to | Worksheet Object