+ Reply to Thread
Results 1 to 3 of 3

Import data from webservice

  1. #1
    Steven Doka
    Guest

    Import data from webservice

    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



  2. #2
    Harlan Grove
    Guest

    Re: Import data from webservice

    "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.



  3. #3
    Registered User
    Join Date
    11-12-2013
    Location
    St.Augustine, FL
    MS-Off Ver
    Excel 2013
    Posts
    4

    Re: Import data from webservice

    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.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1