WorksheetFunction.FilterXML(String, String) Method

Reference

Definition

Namespace:: Microsoft.Office.Interop.Excel

Assembly:: Microsoft.Office.Interop.Excel.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.

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

public:
 System::Object ^ FilterXML(System::String ^ Arg1, System::String ^ Arg2);

public object FilterXML (string Arg1, string Arg2);

Public Function FilterXML (Arg1 As String, Arg2 As String) As Object

Parameters

Arg1: String

Valid xml string.

Arg2: String

XPath query string.

Returns

Object

VARIANT

Remarks

The XPath parameter is limited to 1024 characters.

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

Applies to