Table Definition Part

Content Type:

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

Root Namespace:

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

Source Relationship:

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

An instance of this part type contains a description of a single table and its autofilter information. (The data for the table is stored in the corresponding Worksheet part.)

A package shall contain one Table Definition part per table, and each such part shall be the target of an implicit relationship from the Worksheet (§12.3.24) part that corresponds to the worksheet containing that table.

example:

<Relationships xmlns="…">
  <Relationship Id="rId2" 
    Type="http://…/table" Target="../tables/table1.xml"/>
  <Relationship Id="rId3" 
    Type="http://…/table" Target="../tables/table2.xml"/>
</Relationships>

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

example:

<table xmlns:af="…" … id="2" name="Table2" displayName="Table2" ref="F2:G19"
  totalsRowShown="0" headerRowDxfId="7">
  <autoFilter ref="F2:G19"/>
  <tableColumns count="2">
    <tableColumn id="1" name="Salesman" dataDxfId="9" totalsRowDxfId="6"/>
    <tableColumn id="2" name="Units" dataDxfId="8" totalsRowDxfId="5"/>
  </tableColumns>
  <tableStyle name="TableStyle2" showFirstColumn="0" showLastColumn="0"
    showRowStripes="1" showColumnStripes="1"/>
</table>

When the filter "Salesman equal to Smith" is applied, the <autoFilter> element in table2.xml is extended, as follows:

<autoFilter ref="F2:G19">
  <af:filterColumn colId="0">
    <af:filters>
      <af:filter val="Smith"/>
    </af:filters>
  </af:filterColumn>
</autoFilter>

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

A Table Definition part is permitted to explicit relationships to the following parts defined by this Standard:

Query Table (§12.3.14)

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