Introduction to the Microsoft Office 2003 Reference Schemas

There are a number of schema namespaces used in the XML support for the Microsoft Office Word 2003 and Microsoft Office Excel 2003 programs. These namespaces provide a consistent structure for data used within Office applications and for reliable data exchanges with other applications and systems.

Each namespace has a distinct purpose. This document serves as in introduction to these namespaces and provides a brief description of each namespace, its prefix, and its friendly name.

 

SpreadsheetML Schemas:

The following schemas are used with SpreadsheetML, an XML dialect useful for extracting information from Excel spreadsheets.

uuid:C2F41010-65B3-11d1-A29F-00AA00C14882

Description

This namespace contains the data types that can be used for columns in PivotTables.      

Prefix

dt

Friendly Name

Data Type

 

urn:schemas-microsoft-com:rowset

Description

This namespace is used to describe the attibutes of the row element for PivotTables.

Prefix

rs

Friendly Name

Rowset

 

uuid:BDC6E3F0-6DA3-11d1-A2A3-00AA00C14882

Description

This namespace contains elements and attributes which describe the row elements for PivotTables.

Prefix

s

Friendly Name

Rowset Definition

 

#RowsetSchema

Description

This namespace provides a description of a generalized row element that is used as a model for validation purposes when using PivotTables.

Prefix

z

Friendly Name

Model Row

 

http://schemas.microsoft.com/data/udc

Description

This namespace contains elements and attributes which describe Universal Data Connections that are used in Microsoft Office Excel 2003 to connect to external data sources.

Prefix

udc

Friendly Name

Universal Data Connection

 

http://schemas.microsoft.com/data/udc/soap

Description

This namespace defines external data connections when using the SOAP protocol.

Prefix

udcs

Friendly Name

Universal Data Connection SOAP

 

http://schemas.microsoft.com/data/udc/xmlfile

Description

This namespace defines only one element, File,  which specifies the pathname of an XML file that is used by UDC.

Prefix

udcxf

Friendly Name

Universal Data Connection XML File

 

urn:schemas-microsoft-com:office:spreadsheet

Description

This namespace contains the elements and attributes related to basic spreadsheets functionality.

Prefix

ss

Friendly Name

XML Spreadsheet 2002

 

urn:schemas-microsoft-com:office:excel

Description

This namespace defines elements and attributes used to describe more complex features of Excel, such as PivotTables, worksheet options, and validation.

Prefix

x

Friendly Name

XML Spreadsheet 2000

 

http://schemas.microsoft.com/office/excel/2003/xml

Description

This namespace contains functionality added in Microsoft Office Excel 2003, which mainly includes mapping XML documents

Prefix

x2

Friendly Name

XML Spreadsheet 2003

 

http://schemas.microsoft.com/data/udc/xmlfile

Description

This namespace defines only one element, File,  which specifies the pathname of an XML file that is used by UDC.

Prefix

udcxf

Friendly Name

Universal Data Connection XML File

 

WordprocessingML Schemas:

These are important to document developers and to application developers whose programs will read and write WordprocessingML documents.

http://schemas.microsoft.com/schemaLibrary/2003/core

Description

Contains two elements, SchemaLibrary and Schema, for the schemas referenced by a Word document.

Prefix

sl

Friendly Name

Schema Library

 

http://schemas.microsoft.com/aml/2001/core

Description

Elements used to describe tracked changes (insertions, deletions, and formatting changes), comments, and bookmarks in Word documents only.

Prefix

aml

Friendly Name

Annotation Markup Language

 

http://schemas.microsoft.com/office/word/2003/wordml

Description

This namespace defines the core elements and attributes used to describe document in Microsoft Office Word 2003

Prefix

w

Friendly Name

XML Document 2003

 

http://schemas.microsoft.com/office/word/2003/auxHint

Description

Supplemental XML information added in 2003 that serves as "hints" for transformation of a Word document to HTML format; for example, font, color, border, and absolute positioning information.

Prefix

wx

Friendly Name

Auxiliary XML Document 2003

 

urn:schemas-microsoft-com:office:word

Description

Supplemental XML information that serves as "hints" for transformation of a Word document to HTML format; for example, font, color, border, and absolute positioning information.

Prefix

w10

Friendly Name

Auxiliary XML Document 2002

 

Shared Schemas:

The elements in these schemas are shared by Microsoft Office Word 2003 and Microsoft Office Excel 2003.

urn:schemas-microsoft-com:office:office

Description

Shared office schema. Document properties collection (author, createdate, etc.) and document statistics (word count, etc.)          

Prefix

o

Friendly Name

Common Properties

 

urn:schemas-microsoft-com:office:vml

Description

VML is an application of Extensible Markup Language (XML) 1.0 which defines a format for the encoding of vector information together with additional markup to describe how that information may be displayed and edited.

Prefix

v

Friendly Name

Vector Markup Language