Buying Options
Office 2003 XML
Print $39.95
Add to Cart
Safari Books Online
Add to Cart
What is this?
Print £30.50
Add to Cart
What is this?

Office 2003 XML

Integrating Office with the Rest of the World

By
Evan Lenz, Mary McRae, Simon St. Laurent
Publisher:
O'Reilly Media
Released:
May 2004
Pages:
592
Description

This book explores the relationship between XML and Office 2003, examining how the various products in the Office suite both produce and consume XML. Beginning with an overview of the XML features included in the various Office 2003 components, Office 2003 XML provides quick and clear guidance to anyone who needs to import or export information from Office documents into other systems.

Full Description
Table of Contents

  1. Chapter 1 Microsoft Office and XML

    1. Why XML?

    2. Different Faces of XML

    3. Different XML Faces of Office

    4. Opening Office to the World

  2. Chapter 2 The WordprocessingML Vocabulary

    1. Introduction to WordprocessingML

    2. Tips for Learning WordprocessingML

    3. WordprocessingML's Style of Markup

    4. A Simple Example Revisited

    5. Document Structure and Formatting

    6. Auxiliary Hints in WordprocessingML

    7. More on Styles

  3. Chapter 3 Using WordprocessingML

    1. Endless Possibilities

    2. Creating Word Documents

    3. Extracting Information from Word Documents

    4. Modifying Word Documents

    5. Converting Between WordprocessingML and Other Formats

  4. Chapter 4 Creating XML Templates in Word

    1. Clarifying Use Cases

    2. A Working Example

    3. Word's Processing Model for Editing XML

    4. The Schema Library

    5. How the onload XSLT Stylesheet Is Selected

    6. Merged XML and WordprocessingML

    7. Attaching Schemas to a Document

    8. Schema-Driven Editing

    9. Schema Validation

    10. Document Protection

    11. XML Save Options

    12. Reviewing the XML-Specific Document Options

    13. Steps to Creating the onload Stylesheet

    14. Deploying the Template

    15. Limitations of Word 2003's XML Support

  5. Chapter 5 Developing Smart Document Solutions

    1. What's a Smart Document?

    2. Creating a Smart Document Solution

    3. Coding the Smart Document

    4. Coding in VB.NET

    5. Manifest Files

    6. Other Files

    7. Attaching the Smart Document Expansion Pack

    8. Deploying Your Smart Document Solution

    9. A Few Last Words on Smart Documents

    10. Some Final Thoughts

  6. Chapter 6 Working with XML Data in Excel Spreadsheets

    1. Separating Data and Logic

    2. Loading XML into an Excel Spreadsheet

    3. Editing XML Documents in Excel

    4. Loading and Saving XML Documents from VBA

  7. Chapter 7 Using SpreadsheetML

    1. Saving and Opening XML Spreadsheets

    2. Reading XML Spreadsheets

    3. Extracting Information from XML Spreadsheets

    4. Creating XML Spreadsheets

    5. Editing XML Maps with SpreadsheetML

  8. Chapter 8 Importing and Exporting XML with Microsoft Access

    1. Access XML Expectations

    2. Exporting XML from Access Using the GUI

    3. Importing XML into Access Using the GUI

    4. Automating XML Import and Export

  9. Chapter 9 Using Web Services in Excel, Access, and Word

    1. What Are Web Services?

    2. The Microsoft Office Web Services Toolkit

    3. Accessing a Simple Web Service from Excel

    4. Accessing More Complex Web Services

    5. Accessing REST Web Services with VBA

    6. Using Web Services in Access

    7. Using Web Services in Word

  10. Chapter 10 Developing InfoPath Solutions

    1. What Is InfoPath?

    2. InfoPath in Context

    3. Components of an InfoPath Solution

    4. A More Complete Example

    5. Using InfoPath Design Mode

  1. Appendix A The XML You Need for Office

    1. What Is XML?

    2. Anatomy of an XML Document

  2. Appendix B The XSLT You Need for Office

    1. Sorting Out the Acronyms

    2. A Simple Template Approach

    3. A Rule-Based Stylesheet

    4. A More Advanced Example

    5. Conclusion

  3. Appendix C The XSD You Need for Office

    1. What Is XSD?

    2. Creating a Simple Schema

    3. Schema Parts

    4. Working with XML Schema

  4. Appendix D Using DTDs and RELAX NG Schemas with Office

    1. What Are DTDs?

    2. What Is RELAX NG?

    3. How Do I Convert DTDs and RELAX NG to XSD?

  5. Colophon

View Full Table of Contents
Product Details
Title:
Office 2003 XML
By:
Evan Lenz, Mary McRae, Simon St. Laurent
Publisher:
O'Reilly Media
Formats:
  • Print
  • Safari Books Online
Print Release:
May 2004
Pages:
592
Print ISBN:
978-0-596-00538-2
| ISBN 10:
0-596-00538-5
Customer Reviews
About the Authors

  1. Evan Lenz

    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.

    View Evan Lenz's full profile page.

  2. Mary McRae

    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.

    View Mary McRae's full profile page.

  3. Simon St. Laurent

    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.

    View Simon St. Laurent's full profile page.

Colophon

Our look is the result of reader comments, our own experimentation, and feedback from distribution channels. Distinctive covers complement our distinctive approach to technical topics, breathing personality and life into potentially dry subjects. The animal on the cover of Office 2003 XML is a Malay palm civet (Viverra tangalunga). These mammals are native to the Malay peninsula, including parts of Thailand, Singapore, Myanmar, and Malaysia. Like other palm civets, the Malay is around 17-28 inches long with a tail length of 16-26 inches. It weighs from 3 to 10 pounds, and their its color ranges from gray to brown. The markings on its face resemble those of a raccoon. The civet has four anal glands that it uses to expel an extremely strong-smelling secretion that is used to discourage attackers. This musk was once used by perfume makers in their products. However, animal rights groups objected to the cruel harvesting process and most manufacturers now use synthetic alternatives to approximate the scent.

Civets are nocturnal and prefer wooded areas where they can sleep in trees during the day. At night, they hunt for small vertebrates, insects, fruits, and seeds, which they wash down with palm juice. This juice is called "toddy" by the natives, so civets are often referred to as "toddy cats." They are also extremely fond of coffee, and usually ingest the ripest and reddest coffee beans available. They eat only the outer covering of the bean; the rest of it passes through their digestive process unscathed. These excreted beans are then used to roast the world's most expensive and rarest coffee, Kopi Luwak. Philip Dangler was the production editor and proofreader, and Jane Ellin was the copyeditor for Office 2003 XML. Emily Quill and Darren Kelly provided quality control. Angela Howard wrote the index.

Emma Colby designed the cover of this book, based on a series design by Edie Freedman. The cover image is a 19th-century engraving from Royal Natural History. Emma Colby produced the cover layout with QuarkXPress 4.1 using Adobe's ITC Garamond font.

David Futato designed the interior layout. This book was converted by Joe Wizda to FrameMaker 5.5.6 with a format conversion tool created by Erik Ray, Jason McIntosh, Neil Walls, and Mike Sierra that uses Perl and XML technologies. The text font is Linotype Birka; the heading font is Adobe Myriad Condensed; and the code font is LucasFont's TheSans Mono Condensed. The illustrations that appear in the book were produced by Robert Romano and Jessamyn Read using Macromedia FreeHand 9 and Adobe Photoshop 6. The tip and warning icons were drawn by Christopher Bing. This colophon was written by Philip Dangler.

Whenever possible, our books use a durable and flexible lay-flat binding. If the page count exceeds this binding's limit, perfect binding is used.

  • Book cover of Office 2003 XML
Got a Question?
icons
Favicon Service and support by Satisfaction