WEBSERVICE(url)

Returns the results from a webservice.

urlThe url of the web service.

Remarks

* Added in Excel 2013.
* If "url" > 2048 characters, then #VALUE is returned.
* If there is no internet access, then #VALUE! is returned.
* If you are working with a proxy server, then #VALUE! is returned
* If the "url" is not valid, then #VALUE! is returned
* If the result is not valid, then #VALUE! is returned.
* If the result contains more than 32,767 characters, #VALUE! is returned.
* If the protocol used is "ftp://", then #VALUE! is returned
* If the protocol used is "file://", then #VALUE! is returned
* For the Microsoft documentation refer to support.office.com

 A
1=LEFT(WEBSERVICE("http://bettersolutions.com/excel/xml/example.xml"),30) = #VALUE!


© 2019 Better Solutions Limited. All Rights Reserved. © 2019 Better Solutions Limited Top