O'Reilly logo

XML in Office 2003: Information Sharing with Desktop XML by Priscilla Walmsley, Charles F. Goldfarb

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required