FILTERXML

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.

Syntax

FILTERXML(XML Document; XPath expression)

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

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

Mga halimbawa

=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.

Teknikal na impormasyon

Ang function na ito ay magagamit mula noong LibreOffice 4.2.

Ang function na ito ay HINDI bahagi ng Buksan ang Format ng Dokumento para sa Mga Aplikasyon sa Opisina (OpenDocument) Bersyon 1.3. Bahagi 4: Recalculated Formula (OpenFormula) Format pamantayan. Ang name space ay

COM.MICROSOFT.FILTERXML