How to use the WEBSERVICE function
The WEBSERVICE function gets data from a web service on the Internet or Intranet.
The function returns a #VALUE error if the returned value is above the cell limit of 32767 characters.
Formula in cell B2:
Excel Function Syntax
WEBSERVICE(url)
Arguments
url | Required. An URL (Uniform Resource allocator) to a webpage on the internet or the intranet. |
Comments
HTTP:// and HTTPS:// are supported.
An URL larger than 2048 returns #VALUE error.
Protocols like ftp:// and file:// are not supported, the WEBSERVICE function returns #VALUE error.
Functions in 'Web'
The WEBSERVICE function function is one of many functions in the 'Web' category.
How to use the ENCODEURL function
The ENCODEURL function returns a URL-encoded string. Formula in cell C3: =ENCODEURL(B3) Excel Function Syntax ENCODEURL(text) Arguments text Required. The […]
How to use the WEBSERVICE function
The WEBSERVICE function gets data from a web service on the Internet or Intranet. The function returns a #VALUE error […]
How to comment
How to add a formula to your comment
<code>Insert your formula here.</code>
Convert less than and larger than signs
Use html character entities instead of less than and larger than signs.
< becomes < and > becomes >
How to add VBA code to your comment
[vb 1="vbnet" language=","]
Put your VBA code here.
[/vb]
How to add a picture to your comment:
Upload picture to postimage.org or imgur
Paste image link to your comment.
Contact Oscar
You can contact me through this contact form