Documentation/Calc Functions/FILTERXML

From The Document Foundation Wiki
Jump to: navigation, search


Im-jabber.svg

Under construction.
For now, see the system Help files.


Function name:

FILTERXML

Category:

Text

Summary:

Apply a XPath expression to a XML document.

Syntax:

FILTERXML(XML Document; XPath expression)

Returns:

Arguments:

XML Document (required): String containing a valid XML stream.

XPath expression (required): String containing a valid XPath expression.

Additional details:

Examples:

=FILTERXML(WEBSERVICE("wiki.documentfoundation.org/api.php?hidebots=1&days=7&limit=50&action=feedrecentchanges&feedformat=rss");"//lastBuildDate")

Returns information on the last build date of the wiki.

Related LibreOffice functions:

ODF standard:

Equivalent Excel functions: