Chapter 8. Using Web services with spreadsheets Excel Script Developer Task
REST Web services
SOAP Web services
Excel Object Model
In Chapter 7, "Using XML data in spreadsheets", on page 132, we learned how to share XML data between Excel worksheets and local files. But there are other sources for XML data and one of the most important is Web services. Not just public services offered to all Web users, but services your company might deploy to facilitate sharing of its own data among its employees.
In this chapter we'll show you how to share data between Excel worksheets and Web services by writing macros or Excel-based code. SOAP Web services are accessed with essentially the same techniques that we employed for Word in 6.2, "SOAP Web services", on page 121, but incorporating the results is somewhat different.
Skills required
What we covered in the previous chapter on Excel, plus the above-mentioned material in the Word chapter, and the basics of Web services (Chapter 19, "Web services introduction", on page 414 and Chapter 23, "Web services technologies", on page 484).
