[Table of Contents] [docx version]

SpreadsheetML Reference Material - Table of Contents

workbook (Workbook)

This element is the root part of the workbook in SpreadsheetML. It defines the structure of the workbook:

Sheets: represents the collection of worksheets in the workbook. The worksheet is the primary document that you use to store and work with data.

Views: SpreadsheetML defines a collection of Workbook views that define basic window dimensions and position of the workbook. It also defines a collection of Custom Workbook Views that allow the end-user to define a series of rich views on their workbook data. Users can create more than one view of the same workbook without saving separate copies of the workbook.

Properties: the workbook has several property collection that store basic workbook settings, such as the date system to use, file protection settings, calculation settings, and smart tag behaviors.

Names: represent descriptive that represent cells, ranges of cells, formulas, or constant values.

[Example:

<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<workbook xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/5/main"
mlns:r="http://schemas.openxmlformats.org/officeDocument/2006/relationships">
<fileVersion lastEdited="4" lowestEdited="4" rupBuild="4017"/>
<workbookPr date1904="1" vbName="ThisWorkbook" defaultThemeVersion="123820"/>

<bookViews>
<workbookView xWindow="120" yWindow="45" windowWidth="15135"
windowHeight="7650" activeTab="4"/>
</bookViews>

<sheets>
<sheet name="Sheet1" sheetId="1" r:id="rId1"/>
<sheet name="Sheet2" sheetId="2" r:id="rId2"/>
<sheet name="Sheet5" sheetId="3" r:id="rId3"/>
<sheet name="Chart1" sheetId="4" type="chartsheet" r:id="rId4"/>
</sheets>

<definedNames>
<definedName name="MyDefinedName">Sheet3!$A$1:$C$12</definedName>
</definedNames>

<calcPr calcId="122211" calcMode="autoNoTable" refMode="R1C1" iterate="1"
fullPrecision="0"/>

<customWorkbookViews>
<customWorkbookView name="CustomView1"
guid="{CE6681F1-E999-414D-8446-68A031534B57}" maximized="1" xWindow="1"
yWindow="1" windowWidth="1024" windowHeight="547" activeSheetId="1"/>
</customWorkbookViews>

<pivotCaches>
<pivotCache cacheId="0" r:id="rId8"/>
</pivotCaches>

<smartTagPr embed="1" show="noIndicator"/>

<smartTagTypes>
<smartTagType namespaceUri="urn:schemas-openxmlformats-org:office:smarttags"
name="date"/>
</smartTagTypes>
<webPublishing codePage="1252"/>
</workbook>

end example]

Parent Elements

Root element of SpreadsheetML Workbook part

 

Child Elements

Subclause

bookViews (Workbook Views)

§3.2.1

calcPr (Calculation Properties)

§3.2.2

customWorkbookViews (Custom Workbook Views)

§3.2.4

definedNames (Defined Names)

§3.2.6

externalReferences (External References)

§3.2.9

extLst (Future Feature Data Storage Area)

§3.2.10

fileRecoveryPr (File Recovery Properties)

§3.2.11

fileSharing (File Sharing)

§3.2.12

fileVersion (File Version)

§3.2.13

functionGroups (Function Groups)

§3.2.15

oleSize (Embedded Object Size)

§3.2.16

pivotCaches (PivotCaches)

§3.2.18

sheets (Sheets)

§3.2.20

smartTagPr (Smart Tag Properties)

§3.2.21

smartTagTypes (Smart Tag Types)

§3.2.23

webPublishing (Web Publishing Properties)

§3.2.24

webPublishObjects (Web Publish Objects)

§3.2.26

workbookPr (Workbook Properties)

§3.2.28

workbookProtection (Workbook Protection)

§3.2.29

The following XML Schema fragment defines the contents of this element:

<complexType name="CT_Workbook">

   <sequence>

   <element name="fileVersion" type="CT_FileVersion" minOccurs="0" maxOccurs="1"/>

   <element name="fileSharing" type="CT_FileSharing" minOccurs="0" maxOccurs="1"/>

   <element name="workbookPr" type="CT_WorkbookPr" minOccurs="0" maxOccurs="1"/>

   <element name="workbookProtection" type="CT_WorkbookProtection" minOccurs="0" maxOccurs="1"/>

   <element name="bookViews" type="CT_BookViews" minOccurs="0" maxOccurs="1"/>

   <element name="sheets" type="CT_Sheets" minOccurs="1" maxOccurs="1"/>

   <element name="functionGroups" type="CT_FunctionGroups" minOccurs="0" maxOccurs="1"/>

   <element name="externalReferences" type="CT_ExternalReferences" minOccurs="0" maxOccurs="1"/>

   <element name="definedNames" type="CT_DefinedNames" minOccurs="0" maxOccurs="1"/>

   <element name="calcPr" type="CT_CalcPr" minOccurs="0" maxOccurs="1"/>

   <element name="oleSize" type="CT_OleSize" minOccurs="0" maxOccurs="1"/>

   <element name="customWorkbookViews" type="CT_CustomWorkbookViews" minOccurs="0" maxOccurs="1"/>

   <element name="pivotCaches" type="CT_PivotCaches" minOccurs="0" maxOccurs="1"/>

   <element name="smartTagPr" type="CT_SmartTagPr" minOccurs="0" maxOccurs="1"/>

   <element name="smartTagTypes" type="CT_SmartTagTypes" minOccurs="0" maxOccurs="1"/>

   <element name="webPublishing" type="CT_WebPublishing" minOccurs="0" maxOccurs="1"/>

   <element name="fileRecoveryPr" type="CT_FileRecoveryPr" minOccurs="0" maxOccurs="unbounded"/>

   <element name="webPublishObjects" type="CT_WebPublishObjects" minOccurs="0" maxOccurs="1"/>

   <element name="extLst" type="CT_ExtensionList" minOccurs="0" maxOccurs="1"/>

   </sequence>

</complexType>