WEBSERVICE

Veebisisu hankimine antud URI-lt.

Süntaks

WEBSERVICE(URI)

URI: veebiteenuse URI tekstina.

Näide

=WEBSERVICE("http://api.openweathermap.org/data/2.5/forecast?q=Copenhagen,dk&mode=xml&units=metric")

Tagastab sisu veebilehelt "http://api.openweathermap.org/data/2.5/forecast?q=Copenhagen,dk&mode=xml&units=metric"

FILTERXML

Teisendab tekstistringi arvuks.

Süntaks

FILTERXML(XML Document; XPath expression)

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

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

Näide

=FILTERXML(WEBSERVICE("http://api.openweathermap.org/data/2.5/forecast?q=Copenhagen,dk&mode=xml&units=metric");"number(/weatherdata/forecast/time[2]/temperature/@value)")

Returns information on Copenhagen weather temperature.