Buzz
In this article, Mytour will introduce you to information and some examples related to the WEBSERVICE function in Excel, which retrieves data from a web service on the Internet.
WEBSERVICE function
1. Some considerations regarding the WEBSERVICE function in Excel
- The Excel WEBSERVICE function is only available in Excel 2013 and Excel 2016 for Windows.
- Note: The Excel WEBSERVICE function may appear in the function collection in Excel for Mac, but it relies on features of the function for Windows, so the function will not return results on a Mac.
2. Description of the WEBSERVICE function in Excel, retrieving data from web services on the Internet
The WEBSERVICE function in Excel retrieves data from web services on the Internet or Intranet.
3. Syntax of the WEBSERVICE function in Excel, retrieving data from web services on the Internet
The WEBSERVICE function in Excel, which retrieves data from web services on the Internet, has the following syntax: WEBSERVICE(url)
Where: The Url parameter is required, it is the URL of the Web service.
Note:
- If the argument cannot return data, the Excel WEBSERVICE function will return the #VALUE! error message.
- If the arguments in the string are invalid or exceed the 32767 character limit allowed by the cell, the WEBSERVICE function will return the #VALUE! error.
- If the URL of the string contains more than 2048 characters allowed for GET requests, the WEBSERVICE function will return the #VALUE! error.
- For unsupported protocols such as ftp:// or file://, the WEBSERVICE function will return the #VALUE! error.
4. Example of the WEBSERVICE function in Excel, retrieving data from web services on the Internet
Copy the data from the table below and paste it into cell A1 in a new Excel worksheet. To display the formula result, select the formula, then press F2 and Enter. If necessary, you can adjust the column width to view all data.
So in this article, Mytour has just introduced you to the WEBSERVICE function in Excel, retrieving data from web services on the Internet. Additionally, readers can refer to some articles available on Mytour to learn more about the ISERR function, the ISNA function, and the FILTERXM function in Excel.
The VALUE function is one of the functions to extract numbers from a character string in an Excel worksheet. The VALUE function is widely used in today's problems. You can refer to the article about the VALUE function that we introduced earlier.
