Excel Function : WEBSERVICE

Download now!

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.