12.3.24 Worksheet Part

Content Type:

application/vnd.openxmlformats-officedocument.spreadsheetml.worksheet+xml

Root Namespace:

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

Source Relationship:

http://purl.oclc.org/ooxml/officeDocument/relationships/worksheet

An instance of this part type contains all the data, formulas, and characteristics associated with a given worksheet.

A package shall contain exactly one Worksheet part per worksheet, and those parts shall be the target of an explicit relationship from the Workbook (12.3.23) part. Specifically, the id attribute on the sheet element shall reference the desired worksheet part.

[Example: The following Workbook part-relationship item contains three relationships to Worksheet parts, which are stored in the ZIP items worksheets/sheetN.xml:

<Relationships xmlns="…">
  <Relationship Id="rId1"
    Type="http://…/worksheet" Target="worksheets/sheet1.xml"/>
  <Relationship Id="rId2"
    Type="http://…/worksheet" Target="worksheets/sheet2.xml"/>
  <Relationship Id="rId3"
    Type="http://…/worksheet" Target="worksheets/sheet3.xml"/>
  </Relationships>

end example]

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

[Example: This worksheet, has cells in the range B1 to F8. Row 8 contains three cells whose values are calculated using the following formulas: D8=SUM(D5:D7), E8=SUM(E5:E7), and F8= D8-E8:

<worksheet xmlns="…" …>
  <sheetPr/>
  <dimension range="B1:F8"/>
  …
  <sheetData>
    <row r="1" spans="2:6" ht="360">
      <c r="B1" s="1" t="s">
        <v>0</v>
      </c>
    </row>
    …
    <row r="8" spans="2:6" ht="360">
      <c r="D8" s="5">
        <f>SUM(D5:D7)</f>
        <v>2280.5299999999997</v>
      </c>
      <c r="E8" s="5">
        <f>SUM(E5:E7)</f>
        <v>1251.31</v>
      </c>
      <c r="F8" s="6">
        <f>D8-E8</f>
        <v>1029.2199999999998</v>
      </c>
    </row>
  </sheetData>
  …
</worksheet>

end example]

A Worksheet part shall be located within the package containing the relationships part (expressed syntactically, the TargetMode attribute of the Relationship element shall be Internal).

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

• Comments (12.3.3)
• Pivot Table Definitions (12.3.11)
• Printer Settings (15.2.15)
• Query Table Part (12.3.14)
• Single Cell Table Definitions (12.3.19)
• Table Definition (12.3.21)

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

• Drawings (12.3.8)

• Embedded Control Persistence (15.2.9)

• Embedded Object (15.2.10)

• Embedded Package (15.2.11)

• Hyperlinks (15.3)

• Images (15.2.14)

A Worksheet part shall not have implicit or explicit relationships to any other part defined by ISO/IEC 29500.