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.
This extensive function reference list provides detailed information including syntax, arguments, return values, and examples for many of the functions used in Excel formulas. Click on headers to sort table.
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 FILTERXML function
The FILTERXML function extracts specific values from XML content by using the given xpath. The function was introduced in 2013 […]
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