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.
