WEBSERVICE function

Excel 2013 has given a function to fetch data from web (internet or intranet), which is know as WEBSERVICE

As name suggests, this function can be used to get data from a webservice.

Syntax:-

WEBSERVICE(url])

where url is the link surrounded by quotes or a reference to a cell containing link

Below are some possible errors and their description:-

• #N/A! error may come if the web service is not available or if it does not respond before the timeout (3 seconds)
• #VALUE! error may come if arguments are unable to return the data OR argument returns more than allowable cell limit of 32767 characters OR URL string contains more that 2048 characters