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”, ...

Get XML in Office 2003: Information Sharing with Desktop XML now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.