Workbook Part

Content Type(s):

application/vnd.openxmlformats-officedocument.spreadsheetml.main+xmlapplication/vnd.openxmlformats-officedocument.spreadsheetml.template.main+xml

Root Namespace:

http://schemas.openxmlformats.org/spreadsheetml/2006/main

Source Relationship:

http://schemas.openxmlformats.org/officeDocument/2006/relationships/officeDocument

An instance of this part type contains workbook data and references to all of its worksheets.

A package shall contain exactly one Workbook part, and that part shall be the target of a relationship in the package-relationship item.

example:

<Relationships xmlns="…">
  <Relationship Id="rId1" 
    Type="http://…/officeDocument" Target="xl/workbook.xml"/>
</Relationships>

The root element for a part of this content type shall be< workbook>.

example:

<workbook xmlns="…" xmlns:r="…">
  <fileVersion lastEdited="4" lowestEdited="4" rupBuild="3417"/>
  <bookViews>
    <workbookView xWindow="240" yWindow="15" windowWidth="8505"
      windowHeight="6240"/>
  </bookViews>
  <sheets>
    <sheet name="January" tabId="1" r:id="rId1"/>
    <sheet name="February" tabId="2" r:id="rId2"/>
    <sheet name="March" tabId="3" r:id="rId3"/>
  </sheets>
  <workbookPr showObjects="all"/>
  <webPublishing codePage="1252"/>
  <calcPr calcId="122211" fullCalcOnLoad="1"/>
</workbook>

A Workbook part shall be located within the package containing the source relationship (expressed syntactically, the @TargetMode attribute of the <Relationship> element shall be Internal).

A Workbook part is permitted to have implicit relationships to the following parts defined by this Standard:

Additional Characteristics (§15.2.1)
Bibliography (§15.2.3)
Calculation Chain (§12.3.1)
Cell Metadata (§12.3.10)
Connections (§12.3.4)
Custom XML Mappings (§12.3.6)
Custom XML Data Storage (§15.2.4)
Shared String Table (§12.3.15)
Shared Workbook Revision Headers (§12.3.16)
Shared Workbook User Data (§12.3.18)
Styles (§12.3.20)
Theme (§14.2.7)
Thumbnail (§15.2.14)
Volatile Dependencies (§12.3.22)

A Workbook part is permitted to have explicit relationships to the following parts defined by this Standard:

Chartsheet (§12.3.2)
Dialogsheet (§12.3.7)
External Workbook References (§12.3.8)
Pivot Table Cache Definition (§12.3.12)
Worksheet (§12.3.24)

A Workbook part shall not have implicit or explicit relationships to any other part defined by this Standard.