Worksheet Part

Content Type:

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

Root Namespace:

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

Source Relationship:

http://schemas.openxmlformats.org/officeDocument/2006/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:

<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>

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

example:

<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>

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.