Excel Function : WEBSERVICE
Returns data from a web service.
Microsoft Excel Reference Page
Syntax and Description of the WEBSERVICE Excel Function
I am trying to extract the data from web by using the WEBSERVICE function in excel. However, I am facing problem to get the syntax for this function. There is one example which is: =WEBSERVICE("http://www.webservicex.net/globalweather.asmx/GetWeather?CityName=London&CountryName=UnitedKingdom") I have tried to use the above example but not working. I have to get the data from the web. Please help me.
About WEBSERVICE Excel Function
The WEBSERVICE function returns data from a web service by connecting to a SOAP Web server and making SOAP requests.