This function returns specific data from the XML content using the specified XPath.

Syntax

FILTERXML(xml,xpath)

Arguments

This function has the following arguments:

Argument	Description
xml	Refers to a valid XML formatted string
xpath	Refers to a standard XPath formatted string

Remarks

If the XML string is invalid or if it contains a namespace with a prefix which is not valid, this function returns a #VALUE! error value.

Data Types

Accepts string data. Returns string data.

Examples

FILTERXML(A3,"//cd/@title")

Version Available

This function is available in Spread for Windows Forms 11.0 or later.