Synopses & Reviews
In Microsoft's Office 2003, users experience the merger of the power of the classic Office suite of applications 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.
The first book on the market to provide in-depth coverage on the intersection of Office 2003 and XML.
About the Author
Evan Lenz is principal of Lenz Consulting Group, an XML consulting firm. He's author of XSLT 1.0 Pocket Reference and co-author of Office 2003 XML, has served as invited expert on the W3C XSL Working Group, and most recently has taken on XBRL consulting projects, for clients including XBRL International. Lenz Consulting Group provides an array of services including content strategy consulting, custom XML training, XML information modeling, XQuery, XSLT, and XSL-FO development, specification design, and representation on standards bodies.
Mary McRae is the Director of Technical Committee Administration for OASIS, the Organization for the Advancement of Structured Information Standards, and as such provides front-line support for OASIS committees and the standards they produce. She works with OASIS TC chairs, guiding them through the OASIS technical process and helping them reach the goals and objectives of their charters. Mary also serves on the OASIS Technical Advisory Board. She joined the OASIS staff in 2004, but she has been an active member of the Consortium since 1995, serving on the OASIS Board of Directors in 1999. Mary became involved in structured markup languages in 1992, while working for Butterworth Legal Publishers, where she mastered the nuances of document analysis, DTD development, structured editors, and content management systems. Later, as Vice President of XML Solutions and Principal XML Technologist for DMSi, she used her skills at project management, needs analysis, requirements definition, product selection, schema development, application customization, and training to help clients avoid the pitfalls she encountered herself as an early adopter. Sandwiched in between, Mary was the Manager of Sales Support for Xyvision (now XyEnterprise), focusing on SGML/XML content management solutions. Mary is co-author of "Office 2003 XML" and a frequent speaker at industry conferences. In her spare time, Mary is a textile artist. She is based in Bethlehem, New Hampshire, USA.
Simon St. Laurent is a web developer, network administrator, computer book author, and XML troublemaker living in Ithaca, NY. His books include XML: A Primer, XML Elements of Style, Building XML Applications, Cookies, and Sharing Bandwidth. He is a contributing editor to XMLhack.com and an occasional contributor to XML.com.
Table of Contents
Preface; Who Should Read This Book; Who Should Not Read This Book; Organization of This Book; Supporting Books; Conventions Used in This Book; Using Code Examples; How to Contact Us; Acknowledgments; Chapter 1: Microsoft Office and XML; 1.1 Why XML?; 1.2 Different Faces of XML; 1.3 Different XML Faces of Office; 1.4 Opening Office to the World; Chapter 2: The WordprocessingML Vocabulary; 2.1 Introduction to WordprocessingML; 2.2 Tips for Learning WordprocessingML; 2.3 WordprocessingML's Style of Markup; 2.4 A Simple Example Revisited; 2.5 Document Structure and Formatting; 2.6 Auxiliary Hints in WordprocessingML; 2.7 More on Styles; Chapter 3: Using WordprocessingML; 3.1 Endless Possibilities; 3.2 Creating Word Documents; 3.3 Extracting Information from Word Documents; 3.4 Modifying Word Documents; 3.5 Converting Between WordprocessingML and Other Formats; Chapter 4: Creating XML Templates in Word; 4.1 Clarifying Use Cases; 4.2 A Working Example; 4.3 Word's Processing Model for Editing XML; 4.4 The Schema Library; 4.5 How the onload XSLT Stylesheet Is Selected; 4.6 Merged XML and WordprocessingML; 4.7 Attaching Schemas to a Document; 4.8 Schema-Driven Editing; 4.9 Schema Validation; 4.10 Document Protection; 4.11 XML Save Options; 4.12 Reviewing the XML-Specific Document Options; 4.13 Steps to Creating the onload Stylesheet; 4.14 Deploying the Template; 4.15 Limitations of Word 2003's XML Support; Chapter 5: Developing Smart Document Solutions; 5.1 What's a Smart Document?; 5.2 Creating a Smart Document Solution; 5.3 Coding the Smart Document; 5.4 Coding in VB.NET; 5.5 Manifest Files; 5.6 Other Files; 5.7 Attaching the Smart Document Expansion Pack; 5.8 Deploying Your Smart Document Solution; 5.9 A Few Last Words on Smart Documents; 5.10 Some Final Thoughts; Chapter 6: Working with XML Data in Excel Spreadsheets; 6.1 Separating Data and Logic; 6.2 Loading XML into an Excel Spreadsheet; 6.3 Editing XML Documents in Excel; 6.4 Loading and Saving XML Documents from VBA; Chapter 7: Using SpreadsheetML; 7.1 Saving and Opening XML Spreadsheets; 7.2 Reading XML Spreadsheets; 7.3 Extracting Information from XML Spreadsheets; 7.4 Creating XML Spreadsheets; 7.5 Editing XML Maps with SpreadsheetML; Chapter 8: Importing and Exporting XML with Microsoft Access; 8.1 Access XML Expectations; 8.2 Exporting XML from Access Using the GUI; 8.3 Importing XML into Access Using the GUI; 8.4 Automating XML Import and Export; Chapter 9: Using Web Services in Excel, Access, and Word; 9.1 What Are Web Services?; 9.2 The Microsoft Office Web Services Toolkit; 9.3 Accessing a Simple Web Service from Excel; 9.4 Accessing More Complex Web Services; 9.5 Accessing REST Web Services with VBA; 9.6 Using Web Services in Access; 9.7 Using Web Services in Word; Chapter 10: Developing InfoPath Solutions; 10.1 What Is InfoPath?; 10.2 InfoPath in Context; 10.3 Components of an InfoPath Solution; 10.4 A More Complete Example; 10.5 Using InfoPath Design Mode; The XML You Need for Office; What Is XML?; Anatomy of an XML Document; The XSLT You Need for Office; Sorting Out the Acronyms; A Simple Template Approach; A Rule-Based Stylesheet; A More Advanced Example; Conclusion; The XSD You Need for Office; What Is XSD?; Creating a Simple Schema; Schema Parts; Working with XML Schema; Using DTDs and RELAX NG Schemas with Office; What Are DTDs?; What Is RELAX NG?; How Do I Convert DTDs and RELAX NG to XSD?; Colophon;