XML in Office 2003:
Information Sharing with Desktop XML

Forward by Jean Paoli, Microsoft XML Architect and co-editor of the W3C XML specification

Over 200,000 Goldfarb Series books sold!

CD-ROM with 60-day full-function free trial of Microsoft® InfoPath™

XML in Office 2003 cover

(Imprint: Prentice Hall PTR)
Series: The Charles F. Goldfarb Definitive XML Series
Paperback (First Edition) - 570 pages
Publication Date: December 29, 2003
Author: Charles F. Goldfarb and Priscilla Walmsley
ISBN: 0-13-142193-X

Microsoft Office 2003 Professional Edition has finally brought XML to the rest of us. Thanks to its native support for custom XML schemas, developers can use the world's most popular office suite as a smart client and XML editor for business integration, content management, and Web services. This book shows you step-by-step how to tap Office's XML power for your own applications.

Sample Chapter

Meet the Office family members and see how they use XML in several information sharing scenarios. It's all in Chapter 3, which you can download here (838KB) for your personal use.

About the Authors

CHARLES F. GOLDFARB is the father of XML Technology. He invented SGML, the Standard Generalized Markup Language on which both XML and HTML are based. He is also co-author of Charles F.Goldfarb's XML Handbook, now in its Fifth Edition with more than 100,000 copies in print in six languages.

PRISCILLA WALMSLEY is a developer of the XML Schema Recommendation on which Office 2003's XML support is built. She is a consultant specializing in XML architecture and data management, a power user of Microsoft Office, and the author of Definitive XML Schema.

Publisher's Description (From the Covers)

Front cover:

Back cover:

From the Foreword by Jean Paoli, Microsoft XML architect and co-editor of the W3C XML specification

XML enabled the transfer of information from server to server and server to client, even in cross-platform environments. But the desktop, where documents are created and analyzed by millions of information workers, could not easily participate. Business-critical information was locked inside data storage systems or individual documents, forcing companies to adopt inefficient and duplicative business processes.

This is a book on re-inventing the way millions of people write and interact with documents. It succeeds in communicating the novel underlying vision of Office 2003 XML while focusing on task-oriented, hands-on skills for using the product.

Desktop XML affects every Office Professional Edition user!

It transforms millions of desktop computers from mere word processors into rich clients for Web services, editing front-ends for XML content management systems, and portals for XML-based application integration.

And this book shows you how to benefit from it. You'll learn exactly what XML can do for you, and you'll master its key concepts, all in the context of the Office products you already know and use.

With 200 tested and working code and markup examples and over 150 screenshots and illustrations from the actual shipped product (not betas), you'll see step by step how:

BONUS XML SKILLS SECTION! All the XML expertise you'll need, adapted for Office 2003 users from the best-selling Charles F.Goldfarb's XML Handbook, Fifth Edition: the XML language, XML Schema, XPath, XSLT, Web services ...and more!

Table of Contents

PrefaceWhat do you give the software that has everything?xxi
Forewordby Jean Paoli, Microsoft Office XML Architectxxvi
Part 1Introducing Desktop XML2
Chapter 1Desktop XML: The reason why4
Chapter 2XML concepts for Office users20
Chapter 3XML in Office44
Part 2Working with XML in Office58
Chapter 4Creating and editing XML documents60
Chapter 5Rendering and presenting XML documents86
Chapter 6Using external XML data in documents114
Chapter 7Using XML data in spreadsheets132
Chapter 8Using Web services with spreadsheets160
Chapter 9Designing and using forms180
Chapter 10Using scripts with forms226
Chapter 11Using secondary data sources with forms250
Chapter 12Access databases and XML266
Chapter 13Publishing XML to the Web with FrontPage294
Chapter 14Developing Office XML applications318
Part 3XML Tutorials348
Chapter 15The XML language350
Chapter 16Namespaces376
Chapter 17XPath primer384
Chapter 18XSL Transformations (XSLT)392
Chapter 19Web services introduction414
Chapter 20XML Jargon Demystifier™428
Chapter 21Datatypes442
Chapter 22XML Schema (XSDL)466
Chapter 23Web services technologies484
Chapter 24XML Path Language (XPath)498


We don't report slips of the keyboard that aren't likely to confuse a reader (although we fix them in later printings). However, we do report known substantive errors. At the moment, there is one.

In Example 18-17 on page 406, the fourth from the last line should be changed from:
<xsl:apply-templates select="title"/>
<h2><xsl:value-of select="title"/></h2>

To Charles F. Goldfarb's All the XML Books in Print ...

To Charles F. Goldfarb's SGML Source Home Page.

Copyright ©2005 Charles F. Goldfarb. All rights reserved. Information on this site cannot be used or cited for any commercial purpose, although links to the site are welcome. Any questions, comments, or suggestions? Write to Charles at this domain.