HOME

TheInfoList



OR:

The Microsoft Office XML formats are
XML Extensible Markup Language (XML) is a markup language and file format for storing, transmitting, and reconstructing data. It defines a set of rules for encoding electronic document, documents in a format that is both human-readable and Machine-r ...
-based document formats (or
XML schema An XML schema is a description of a type of XML document, typically expressed in terms of constraints on the structure and content of documents of that type, above and beyond the basic syntactical constraints imposed by XML itself. These constrai ...
s) introduced in versions of
Microsoft Office Microsoft Office, MS Office, or simply Office, is an office suite and family of client software, server software, and services developed by Microsoft. The first version of the Office suite, announced by Bill Gates on August 1, 1988, at CO ...
prior to
Office 2007 Microsoft Office 2007 (codenamed Office 12) is an office suite for Windows, developed and published by Microsoft. It was officially revealed on March 9, 2006 and was the 12th version of Microsoft Office. It was released to manufacturing on Novemb ...
. Microsoft Office XP introduced a new XML format for storing Excel spreadsheets and Office 2003 added an XML-based format for Word documents. These formats were succeeded by
Office Open XML Office Open XML (also informally known as OOXML) is a zipped, XML-based file format developed by Microsoft for representing spreadsheets, charts, presentations and word processing documents. Ecma International standardized the initial version ...
(ECMA-376) in
Microsoft Office 2007 Microsoft Office 2007 (codenamed Office 12) is an office suite for Windows, developed and published by Microsoft. It was officially revealed on March 9, 2006 and was the 12th version of Microsoft Office. It was released to manufacturing on Novemb ...
.


File formats

* Microsoft Office Word 2003 XML Format — WordProcessingML or WordML () * Microsoft Office Excel 2002 and Excel 2003 XML Format — SpreadsheetML () * Microsoft Office Visio 2003 XML Format — DataDiagramingML (, , ) * Microsoft Office InfoPath 2003 XML Format — XML FormTemplate () (Compressed XML templates in a Cabinet file) * Microsoft Office InfoPath 2003 XML Format — XMLS FormTemplate () (Compressed XML templates in a Cabinet file)


Limitations and differences with Office Open XML

Besides differences in the schema, there are several other differences between the earlier Office XML schema formats and Office Open XML. * Whereas the data in
Office Open XML Office Open XML (also informally known as OOXML) is a zipped, XML-based file format developed by Microsoft for representing spreadsheets, charts, presentations and word processing documents. Ecma International standardized the initial version ...
documents is stored in multiple parts and compressed in a ZIP file conforming to the Open Packaging Conventions, Microsoft Office XML formats are stored as plain single monolithic
XML Extensible Markup Language (XML) is a markup language and file format for storing, transmitting, and reconstructing data. It defines a set of rules for encoding electronic document, documents in a format that is both human-readable and Machine-r ...
files (making them quite large, compared to OOXML and the Microsoft Office legacy binary formats). Also, embedded items like pictures are stored as binary encoded blocks within the
XML Extensible Markup Language (XML) is a markup language and file format for storing, transmitting, and reconstructing data. It defines a set of rules for encoding electronic document, documents in a format that is both human-readable and Machine-r ...
. In the case of Office Open XML, the header, footer, comments of a document etc. are all stored separately. * XML Spreadsheet documents cannot store
Visual Basic for Applications Visual Basic for Applications (VBA) is an implementation of Microsoft's event-driven programming language Visual Basic 6, Visual Basic 6.0 built into most desktop Microsoft Office applications. Although based on pre-.NET Visual Basic, which is no ...
macros, auditing tracer arrows, charts and other graphic objects, custom views, drawing object layers, outlining, scenarios, shared workbook information and
user-defined function A user-defined function (UDF) is a function provided by the user of a program or environment, in a context where the usual assumption is that functions are built into the program or environment. UDFs are usually written for the requirement of its c ...
categories. In contrast, the newer
Office Open XML Office Open XML (also informally known as OOXML) is a zipped, XML-based file format developed by Microsoft for representing spreadsheets, charts, presentations and word processing documents. Ecma International standardized the initial version ...
formats support full document fidelity. * Poor
backward compatibility In telecommunications and computing, backward compatibility (or backwards compatibility) is a property of an operating system, software, real-world product, or technology that allows for interoperability with an older legacy system, or with Input ...
with the version of Word/Excel prior to the one in which they were introduced. For example, Word 2002 cannot open Word 2003 XML files unless a third-party converter add-in is installed. Microsoft has released a ''Word 2003 XML Viewer'' which allows WordProcessingML files saved by Word 2003 to be viewed as
HTML Hypertext Markup Language (HTML) is the standard markup language for documents designed to be displayed in a web browser. It defines the content and structure of web content. It is often assisted by technologies such as Cascading Style Sheets ( ...
from within
Internet Explorer Internet Explorer (formerly Microsoft Internet Explorer and Windows Internet Explorer, commonly abbreviated as IE or MSIE) is a deprecation, retired series of graphical user interface, graphical web browsers developed by Microsoft that were u ...
.Word 2003 XML Viewer
/ref> For
Office Open XML Office Open XML (also informally known as OOXML) is a zipped, XML-based file format developed by Microsoft for representing spreadsheets, charts, presentations and word processing documents. Ecma International standardized the initial version ...
, Microsoft provides converters for Office 2003, Office XP and Office 2000. * Office Open XML formats are also defined for PowerPoint 2007, equation editing (Office
MathML Mathematical Markup Language (MathML) is a pair of mathematical markup languages, an application of XML for describing mathematical notations and capturing both its structure and content. Its aim is to natively integrate mathematical formulae ...
), vector drawing, charts and text art (DrawingML).


Word XML format example

This is the title Darl McBride Bill Gates 1 0 2007-03-15T23:05:00Z 2007-03-15T23:05:00Z 1 6 40 SCO Group, Inc. 1 1 45 11.6359 This is the first paragraph This is a heading


Excel XML spreadsheet example

ID Project Reporter Assigned To Priority Severity Reproducibility Product Version Category Date Submitted OS OS Version Platform View Status Updated Summary Status Resolution Fixed in Version 0000033 CognaLearn Intedashboard janardhana.l normal text always GUI 2016-10-14 public 2016-10-14 IE8 browser_Modules screen tool tip text is shown twice new open


See also

*
List of document markup languages The following is a list of document markup languages. You may also find the List of markup languages of interest. Well-known document markup languages * HyperText Markup Language (HTML) – an ad hoc markup language that was originally created f ...
* Comparison of document markup languages


References


Overview of Office 2003 Developer Technologies
* ''Office 2003 XML''.


External links


MSDN: XML Spreadsheet Reference (2014)

MSDN: Word 2003 XML Reference (2010)
* {{Authority control Computer file formats Markup languages XML formats Open formats XML-based standards