The Table XML

The <tableParts> collection appears after the <sheetData> section of the sheet. This sheet references a table whose relationship Id @r:id value is rId1.

The Table definition XML for this example:

<table xmlns= … id="8" name="Table19" displayName="Table19" ref="B3:D10"
  totalsRowCount="1">
  <autoFilter ref="B3:D10"/>
  <tableColumns count="3">
    <tableColumn id="1" name="State" totalsRowLabel="Count"
      totalsRowDxfId="0"/>
    <tableColumn id="2" name="City"/>
    <tableColumn id="3" name="Zipcode" totalsRowFunction="count"/>
  </tableColumns>
  <tableStyleInfo name="TableStyleMedium16" showFirstColumn="0"
    showLastColumn="1"
    showRowStripes="1" showColumnStripes="0"/>
</table>

@name indicates that the Table's name is Table19, and the @ref value indicates that it occupies the range B3:D10 on the relevant sheet. @totalsRowCount value of 1 indicates that this Table's total row is visible.

The <autoFilter> element indicates that the autoFilter feature is applied to the range B3:D10. The <tableColumns> collection indicates there are 3 columns in the table, whose names are "State", "City", and "Zipcode". Furthermore, the column titled "State" has a label in the total row, whose caption is "Count", and the column titled "Zipcode" has a total row function applied, whose function is "count".

The <tableStyleInfo> element indicates various attributes of this Table's style and formatting. In this example, @name indicates that the Table style named "TableStyleMedium16" has been applied. Additionally, even though formatting has been defined by this table style to indicate uniquely the first column of the table, since @showFirstColumn is set to 0 (false), this first column formatting will not be applied to the table. The same is true for column stripes. Since @showColumnStripes is set to 0 (false), even though formatting for column stripes is defined by the table style, it is not applied to this table. However, both row striping and last column formatting is set to be applied to this table, as indicated by @showRowStripes and @showLastColumn.