Spread.NET 18 Formula Reference
Formula Functions / Functions D to G / FILTERXML
In This Topic
    FILTERXML
    In This Topic

    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.