DocumentID: ECMA-376/Part1/12.3.24
Title: ECMA-376, Part1: 12.3.24 Worksheet Part
Extracted-From: ECMA-376 Office Open XML File Formats, 1st Edition / December 2006
Warning: Coverted to HTML format by a script known to have bugs

• Next: 12.4 External Workbooks
• Up: 12.3 Part Summary
• Table of contents: Table of contents
• Previous: 12.3.23 Workbook Part

12.3.24 Worksheet Part

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 source relationship (expressed syntactically, the TargetMode attribute of the Relationship element shall be Internal).

A Worksheet part is permitted to contain implicit relationships to the following parts defined by this Standard:

• Comments (§12.3.3)
• Pivot Table Definitions (§12.3.11)
• Printer Settings (§15.2.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 this Standard:

• Drawings (§12.3.8)
• Embedded Control Persistence (§15.2.8)
• Embedded Object (§15.2.9)
• Embedded Package (§15.2.10)
• Hyperlinks (§15.3)
• Images (§15.2.13)
• VML Drawing (§15.2.17)

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