Export (0) Print
Expand All
Expand Minimize

WorksheetFunction.FilterXML Method (Excel)

Office 2013

Get specific data from the returned XML, typically from a WebService function call.

Version Added: Excel 2013

expression .FilterXML(Arg1,Arg2)

expression A variable that represents a WorksheetFunction Members (Excel) object.

Parameters

Name

Required/Optional

Data type

Description

Arg1

Required

STRING

Valid xml string.

Arg2

Required

STRING

XPath query string.

Remarks

The XPath parameter is limited to 1024 characters.

The FILTERXML function returns results that are parsed via the user specified data locale.

Return value

VARIANT

Show:
© 2014 Microsoft