Moving MS Excel data to a website via a web service

    Hi,


    First of all please apologize if this is not appropriate place to start this thread. I'm exploring different options to get data from excel file to website using webservice. Can someone please suggest a way to get it done, I mean what type of add-ons are required, if any, and what would be the process like to move data?


    Thanks for your help in advance.


    -Rockstar

    Re: Moving MS Excel data to a website via a web service


    Generally you wouldn't need any add-ons, VBA could automate this, but the complexity of the VBA would depend on the webservice. Without seeing what the webservice expects, it's difficult to speculate though

    Re: Moving MS Excel data to a website via a web service


    Hi Kyle,


    Thanks for your response. As I'm new with WBS, this question may sound rhetorical. By 'what webservice expects' you mean what the schema is like? Can you please let me know what exactly you would need to know to help further.


    Thanks,


    -Rockstar-

    Re: Moving MS Excel data to a website via a web service


    Yeah, is it soap? If so do you have the schema? Is it purely xml based?

    Re: Moving MS Excel data to a website via a web service


    Yes, I believe it is xml based. Do you know how I can get the schema file from web services so that I can point excel to it when converting excel data to xml?

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!

Register Yourself Login