I've got a web service and I'm looking for a way for my users to easily
consume those services in Excel. So..after scanning the Excel help and
visiting MSDN I'm still stumped. How do you do it without having to write
VBA code?
Steven
I've got a web service and I'm looking for a way for my users to easily
consume those services in Excel. So..after scanning the Excel help and
visiting MSDN I'm still stumped. How do you do it without having to write
VBA code?
Steven
"Steven Doka" <[email protected]> wrote...
>I've got a web service and I'm looking for a way for my users to
>easily consume those services in Excel. So..after scanning the
>Excel help and visiting MSDN I'm still stumped. How do you do it
>without having to write VBA code?
I believe you'd need to write an interface for your web service that would
allow Excel to use web queries to 'consume' it.
If you are using Excel 2013, then you can use the webservice function.
In order to parse the result set returned in XML format, you would need to use the filterxml function also.
Here is an example:
=filterxml(webservice(URLforYourWebService),"XPATH" expression)
Last edited by raghunathmenon; 11-12-2013 at 02:11 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks