+612 9045 4394
Office 2003 XML for Power Users : Books for Professionals by Professionals - Matthew MacDonald

Office 2003 XML for Power Users

Books for Professionals by Professionals

Paperback Published: 14th January 2004
ISBN: 9781590592649
Number Of Pages: 323

Share This Book:
Ships in 7 to 10 business days

If you're an experienced Office user who wants to use XML to unlock data, or one of the many IT professionals who wants to learn about XML implementation in Office 2003, then this is the ideal book for you! No prior XML or programming experience is necessary. Optional code snippets and downloadable examples help illustrate the more advanced tips, tricks, and techniques in the book.

Popular author Matthew MacDonald introduces you to XML standards, like schemas, XPath, and XML transforms. Then he explains the philosophy of XML, and shows you how to transform data in the Enterprise using XML technology. This book will enable you to maximize the tools already within your reach.

You'll learn to feed an Excel purchase order into an XML inventory management system. Or, you can create a Word document that contains a newspaper article and "reads" information about resume candidates, then generates a new summary document--without even installing Office. The document revolution has now begun!

Industry Reviews

This book quickly introduces the XML standards (including schemas, XPath, and XML transforms), and the philosophy of XML. It then shows how the XML technology embedded into Office 2003 can be used to share and transform data in an enterprise. This book is aimed at experienced Office users that want to use XML to unlock the data in Office spreadsheets and documents. A secondary audience is IT professionals seeking to learn about XML and how it is implemented in Office 2003.

About the Authorp. xiii
About the Technical Reviewerp. xv
Acknowledgmentsp. xvii
Introductionp. xix
Understanding XMLp. 1
A Brief History of XMLp. 1
The XML Philosophyp. 2
XML vs. HTMLp. 4
What XML Is Notp. 5
The Rules of XMLp. 7
The Document Prologp. 7
Elements and Tagsp. 9
Element Contentsp. 11
Element Relationsp. 12
Attributesp. 14
Entity Referencesp. 16
Commentsp. 17
Well-Formed XMLp. 19
Types of XML Documentsp. 20
Data-Centric XMLp. 20
Document-Centric XMLp. 23
XML Namespacesp. 25
Namespaces and Attributesp. 29
Testing Namespacesp. 30
The Promise of XML in Office 2003p. 30
Wordp. 31
Excelp. 32
Accessp. 33
Visiop. 33
PowerPoint, Outlook, and FrontPagep. 34
InfoPathp. 34
The Last Wordp. 35
XML Schemap. 37
The Role of XML Schemap. 38
XML Schema and Other Standardsp. 39
Testing a Schemap. 39
Basic Schemasp. 41
Validating with the Simple Schemap. 42
Simple and Complex Typesp. 44
Anonymous and Named Typesp. 46
Groups and Sequencesp. 51
Minimums, Maximums, and Listsp. 54
Mixed Content Typep. 56
Attributesp. 58
The Any Elementp. 60
Data Typesp. 61
Numeric Data Typesp. 61
String Typesp. 63
Date and Time Typesp. 63
The Boolean Typep. 64
Binary Typesp. 64
A Typed Schemap. 65
Deriving Custom Data Typesp. 67
Restricting String Lengthp. 68
Restricting Number Rangesp. 69
Restricting Values with Enumerationsp. 70
Restricting Values with Patternsp. 70
Schemas and Namespacesp. 72
Locating Schemasp. 74
The Last Wordp. 77
Mapping XML in Excelp. 79
XML Listsp. 80
Importing and Exporting a Basic XML Listp. 80
Editing, Refreshing, and Exporting the Listp. 83
Sorting and Filtering Listsp. 86
Mapping Cells to XMLp. 89
Importing Complex Structuresp. 92
Tables and Headersp. 92
Multitabular Datap. 96
Relational (or Nested) Datap. 99
Irregular Rowsp. 102
Importing XML Documents with Schemasp. 102
Aggregating and Analyzing XMLp. 107
The Total Rowp. 107
Calculated Columns, Formulas, and Chartsp. 108
Data Miningp. 112
Retrofitting Existing Templatesp. 113
Getting the Data in Visual Basic 6p. 116
The Last Wordp. 118
Mapping XML in Wordp. 121
Viewing an Ordinary XML Filep. 122
Mapping XML with a Schemap. 124
Managing the Schema Libraryp. 126
Creating an XML Document with a Schemap. 128
Saving Mapped XMLp. 132
Opening Mapped XMLp. 134
Schema Validationp. 135
Using Schemas with Mixed Modep. 138
Elements with Attributesp. 138
Using Multiple Schemasp. 140
Hybrid Word XML Documentsp. 143
The Memo Template Solutionp. 143
Placeholders and Tag Viewp. 148
Document Protectionp. 149
Gaps in the Word 2003 XML Supportp. 151
The Last Wordp. 152
Exporting and Importing XML in Accessp. 153
Exporting XMLp. 154
The Exported XMLp. 155
The XML Schemap. 157
The XSL Transformp. 159
Exporting Related Tablesp. 160
Other Export Optionsp. 165
Customizing Exported XML with a Queryp. 167
Importing XMLp. 169
Programmatic Importing and Exportingp. 171
The Last Wordp. 172
WordML and SpreadsheetMLp. 173
The Role of WordML and SpreadsheetMLp. 173
How the Office XML Formats Workp. 174
Dissecting SpreadsheetMLp. 176
A Simple SpreadsheetML Documentp. 177
Spreadsheets with Noncontiguous Rangesp. 182
Numbers and Formulasp. 183
Formatted Spreadsheetsp. 185
Mapped Spreadsheetsp. 187
Dissecting WordMLp. 188
A Simple WordML Documentp. 190
Formatted Documentsp. 194
Documents with Graphicsp. 197
Mapped Documentsp. 199
Getting More Information About WordML Structuresp. 201
Programming with the Office XML Formatsp. 202
Mining Datap. 202
Creating Documentsp. 209
The Last Wordp. 213
Transforming XMLp. 215
The XSL Standardp. 216
The Role of XSLTp. 217
XSLT Basicsp. 218
The Empty Stylesheetp. 218
Building Basic Templatesp. 220
Copying Node Valuesp. 224
Applying Templatesp. 226
Conditional Templatesp. 229
XSLT and Namespacesp. 230
Converting XML to HTMLp. 230
HTML and Tablesp. 233
Changing the Structure of XMLp. 236
XSLT with WordML and SpreadsheetMLp. 236
Office and XSLTp. 237
XSLT in Wordp. 241
Changing WordML to Your Custom XMLp. 246
The Last Wordp. 248
Managing Workflow with XML Web Servicesp. 249
An Overview of the Expense Report Workflowp. 250
Installing the Prerequisitesp. 254
Internet Information Servicesp. 255
.NET Framework and Web Matrixp. 256
The SOAP Toolkitp. 257
Building the Expense Report Workflowp. 258
Creating the Databasep. 258
Creating the Web Service Objectsp. 262
Creating the Web Servicep. 264
Exposing the Web Servicep. 268
Creating the Excel VBA Macrop. 271
Running a Testp. 277
Creating the Summary Web Pagep. 278
Other Scenariosp. 283
The Last Wordp. 284
InfoPathp. 285
An Overview of InfoPathp. 285
When to Use InfoPathp. 286
The Limits of InfoPathp. 287
Designing InfoPath Formsp. 288
Creating a Form Based on a Schemap. 290
Filling Out the Formp. 296
Complex Formsp. 298
Publishing Formsp. 303
InfoPath and Web Servicesp. 305
Designing a Query Formp. 309
Designing a Data Formp. 311
Submitting an Expense Reportp. 312
The Last Wordp. 313
Indexp. 315
Table of Contents provided by Ingram. All Rights Reserved.

ISBN: 9781590592649
ISBN-10: 1590592646
Series: Books for Professionals by Professionals
Audience: General
Format: Paperback
Language: English
Number Of Pages: 323
Published: 14th January 2004
Publisher: Apress
Country of Publication: US
Dimensions (cm): 23.11 x 17.83  x 2.36
Weight (kg): 0.67