Microsoft Office Tutorials and References
In Depth Information
The ENCODEURL function URL encodes the argument text. Note that you will
rarely pass the entire URL to the function. This would encode characters
such as http://into http%3A%2F%2F. This is not necessary and will not
Instead, you usually pass just the arguments to ENCODEURL, as in this ex-
Note that you should experiment by using WEBSERVICE with and without
ENCODEURL. The weather.yahoo.com example works better with ENCODEURL,
but the Twitter API in the next section does not require ENCODEURL.
Returning XML or JSON Using the
Returning XML or JSON Using the WEBSERVICE
The WEBSERVICE function is new in Excel 2013. You pass a URL to the func-
tion. Excel goes out to the Web and instead of returning the data to a browser,
it returns the entire web page to one cell in Excel.
Returns data from a web service on the Internet or an intranet. urlmust be
2,048 characters or less. The data returned from the web service must be
less than 32,767 characters that fit in a cell. WEBSERVICE does not work
with ftp:// or file:// protocols. If the arguments are invalid and cannot return
data, WEBSERVICE returns the #VALUE! error.
Here is an example of how to build the WEBSERVICE function and how to inter-
11. Enter the search term in cell A2.
22. A formula in A3 encodes the argument with =ENCODEURL(A2).
33. Cell C2 holds the first part of the URL.
44. A formula in C5 concatenates the URL with =C2&A3.