FILTREXML

Apply a XPath expression to a XML document.

XML Path Language (XPath) is a query language that uses path expressions (with a non-XML syntax) to select parts of an XML document.

Sintaxi

FILTREXML(Document XML; expressió XPath)

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

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

Exemples

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

Returns information //lastBuildDate of the XML contents supplied by the WEBSERVICE() function.

Informació tècnica

Aquesta funció és disponible des de la versió 4.2 del LibreOffice.

This function is NOT part of the Open Document Format for Office Applications (OpenDocument) Version 1.3. Part 4: Recalculated Formula (OpenFormula) Format standard. The name space is

COM.MICROSOFT.FILTERXML