Office 2003 XML

Simon St. Laurent, Evan Lenz, Mary Mc Rae

  • 出版商: O'Reilly
  • 出版日期: 2004-06-07
  • 售價: $1,520
  • 貴賓價: 9.5$1,444
  • 語言: 英文
  • 頁數: 590
  • 裝訂: Paperback
  • ISBN: 0596005385
  • ISBN-13: 9780596005382
  • 相關分類: XML
  • 已過版



In Microsoft's Office 2003 users experience power of the classic Office suite of applications merge red with the fluidity of data exchange inherent in XML. With XML at its heart, the new version of Microsoft's desktop suite liberates the information stored in millions of documents created with Office software over the past fifteen years, making it available to a wide variety of programs.

Office 2003 XML offers an in-depth exploration of the relationship between XML and Office 2003, examining how the various products in the Office suite both produce and consume XML. Developers will learn how they can connect Microsoft Office to others systems, while power users will learn to create and analyze XML documents using familiar Office tools.

The book begins with an overview of the XML features included in the various Office 2003 components, and explores in detail how Word, Excel, and Access interact with XML. This book covers both the user interface side, creating interfaces so that users can comfortably (and even unknowingly) work with XML, and the back end, exposing Office information to other processes. It also looks at Microsoft's new InfoPath application and how it fits with the rest of Office. Finally, the book's appendices introduce various XML technologies that may be useful in working with Office, including XSLT, W3C XML Schema, RELAX NG, and SOAP.
Office 2003 XML provides quick and clear guidance to a anyone who needs to import or export information from Office documents into other systems. Both XML programmers and Office power will learn how to get the most from this powerful new intersection between Office 2003 and XML

Table of Contents


1. Microsoft Office and XML
     Why XML?
     Different Faces of XML
     Different XML Faces of Office
     Opening Office to the World

2. The WordprocessingML Vocabulary
     Introduction to WordprocessingML
     Tips for Learning WordprocessingML
     WordprocessingML's Style of Markup
     A Simple Example Revisited
     Document Structure and Formatting
     Auxiliary Hints in WordprocessingML
     More on Styles

3. Using WordprocessingML
     Endless Possibilities
     Creating Word Documents
     Extracting Information from Word Documents
     Modifying Word Documents
     Converting Between WordprocessingML and Other Formats

4. Creating XML Templates in Word
     Clarifying Use Cases
     A Working Example
     Word's Processing Model for Editing XML
     The Schema Library
     How the onload XSLT Stylesheet Is Selected
     Merged XML and WordprocessingML
     Attaching Schemas to a Document
     Schema-Driven Editing
     Schema Validation
     Document Protection
     XML Save Options
     Reviewing the XML-Specific Document Options
     Steps to Creating the onload Stylesheet
     Deploying the Template
     Limitations of Word 2003's XML Support

5. Developing Smart Document Solutions
     What's a Smart Document?
     Creating a Smart Document Solution
     Coding the Smart Document
     Coding in VB.NET
     Manifest Files
     Other Files
     Attaching the Smart Document Expansion Pack
     Deploying Your Smart Document Solution
     A Few Last Words on Smart Documents
     Some Final Thoughts

6. Working with XML Data in Excel Spreadsheets
     Separating Data and Logic
     Loading XML into an Excel Spreadsheet
     Editing XML Documents in Excel
     Loading and Saving XML Documents from VBA

7. Using SpreadsheetML
     Saving and Opening XML Spreadsheets
     Reading XML Spreadsheets
     Extracting Information from XML Spreadsheets
     Creating XML Spreadsheets
     Editing XML Maps with SpreadsheetML

8. Importing and Exporting XML with Microsoft Access
     Access XML Expectations
     Exporting XML from Access Using the GUI
     Importing XML into Access Using the GUI
     Automating XML Import and Export

9. Using Web Services in Excel, Access, and Word
     What Are Web Services?
     The Microsoft Office Web Services Toolkit
     Accessing a Simple Web Service from Excel
     Accessing More Complex Web Services
     Accessing REST Web Services with VBA
     Using Web Services in Access
     Using Web Services in Word

10. Developing InfoPath Solutions
     What Is InfoPath?
     InfoPath in Context
     Components of an InfoPath Solution
     A More Complete Example
     Using InfoPath Design Mode

A. The XML You Need for Office

B. The XSLT You Need for Office

C. The XSD You Need for Office

D. Using DTDs and RELAX NG Schemas with Office