How to import .WSDL files in Excel 2016 (Web Services) RRS feed

  • Question

  • I was using Office Toolkit for Web Services earlier in Excel 2003/2007 version to import classes and methods using .WSDL link.  Now i am using Excel 2016 version. Web Service tool kit is not available for this version.  Is the toolkit is available for Excel 2016 or is there any other option that can be used for importing classes and methods.

    Please advice.

    Wednesday, September 12, 2018 11:36 AM

All replies

  • I needed to do this recently to get web data using a WSDL.  I ended up using C# to create the web service.  I populate an SQLite database.  I call the C# web service from Excel and process the data.  I don't need to write any data to web service. 

    You can call a web service from Power Query to get data but as far as I know there is no way to provide login credentials.
    Wednesday, September 12, 2018 12:55 PM