How to call Web service in Excel using Visual Studio Tools for Office

Sign in to queue

Description

Sometimes, you may want to incorporate data from online resources into your Excel worksheets, like the weather data of a city. This video shows you how to call a weather web service to get online data in Excel using Visual Studio Tools for Office (VSTO).

Embed

Download

Download this episode

Download captions

The Discussion

  • User profile image
    Marak60

    Sorry if I'm missing something, but would it be possible to provide the web service address so that I can run through the application from start to finish?  Or is this a custom web service you've created?  It appears that NOAA and Weather.gov provide such a service, but I can't locate the exact link.

    And please create more videos like this, highlighting the potential of VSTO!

    Thanks!

  • User profile image
    Marak60

    OK, I think this is the weather web service used:

    http://www.webservicex.net/globalweather.asmx?WSDL

    But I still can't figure out how to resolve the "GlobalWeatherSoapClient" object used in the project.

    Still working on it...

     

Add Your 2 Cents