12.3.23 Workbook Part

Content Type(s):

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

Root Namespace:

http://purl.oclc.org/ooxml/spreadsheetml/main

Source Relationship:

http://purl.oclc.org/ooxml/officeDocument/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: The following SpreadsheetML package-relationship item contains a relationship to the Workbook part, which is stored in the ZIP item xl/workbook.xml:

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

end example]

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

[Example: This workbook has three worksheets, named January, February, and March:

<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" sheetId="1" r:id="rId1"/>
    <sheet name="February" sheetId="2" r:id="rId2"/>
    <sheet name="March" sheetId="3" r:id="rId3"/>
  </sheets>
  <workbookPr showObjects="all"/>
  <webPublishing codePage="1252"/>
  <calcPr calcId="122211" fullCalcOnLoad="1"/>
</workbook>

end example]

A Workbook part shall be located within the package containing the relationships part (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 ISO/IEC 29500:

• 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.16)
• Volatile Dependencies (12.3.22)

A Workbook part is permitted to have explicit relationships to the following parts defined by ISO/IEC 29500:

• 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 ISO/IEC 29500.