Web functions
Web functions encode text for URLs, call web services and read XML. Some are not available in every edition of Excel.
3 functions in this category.
Start here
- ENCODEURL
Turns spaces and symbols into URL-safe codes, so you can build query strings for web requests.
- FILTERXML
Digs values out of XML, usually the response from WEBSERVICE.
- WEBSERVICE
Calls a web address and returns the raw response text, often fed into FILTERXML.
All web functions
| Function | What it does | Level | Since | Spills? |
|---|---|---|---|---|
ENCODEURL | Turns spaces and symbols into URL-safe codes, so you can build query strings for web requests. | Intermediate | 2013 | No |
FILTERXML | Digs values out of XML, usually the response from WEBSERVICE. | Advanced | 2013 | Yes |
WEBSERVICE | Calls a web address and returns the raw response text, often fed into FILTERXML. | Advanced | 2013 | No |
Other categories
- Lookup and reference functions
43 functions
- Math and trig functions
80 functions
- Logical functions
19 functions
- Text functions
48 functions
- Date and time functions
25 functions
- Statistical functions
111 functions
- Financial functions
56 functions
- Information functions
21 functions
- Database functions
12 functions
- Engineering functions
54 functions
- Compatibility functions
41 functions
- Cube functions
7 functions
- Add-in and automation functions
5 functions