L.2.4.6 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>

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 is not 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.