Excel Function : WEBSERVICE

Download now!

Excel Function : WEBSERVICE

Category

Web

Description

Returns data from a web service.

Microsoft Excel Reference Page

https://support.office.com/en-us/article/WEBSERVICE-function-0546a35a-ecc6-4739-aed7-c0b7ce1562c4

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.