Skip to Main Content
XML in Office 2003: Information Sharing with Desktop XML
book

XML in Office 2003: Information Sharing with Desktop XML

by Charles F. Goldfarb, Priscilla Walmsley
December 2003
Beginner to intermediate content levelBeginner to intermediate
576 pages
9h 46m
English
Pearson
Content preview from XML in Office 2003: Information Sharing with Desktop XML

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

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Office 2003 XML

Office 2003 XML

Simon St. Laurent, Mary McRae, Evan Lenz
Essential XML: Beyond Markup

Essential XML: Beyond Markup

Don Box, Aaron Skonnard, John Lam

Publisher Resources

ISBN: 013142193XPurchase book