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.