Sheet Properties

Referring back to §3.2.3, note that several sheet-level properties are expressed before the <sheetData> cell table is encountered.

<sheetPr> indicates that an AutoFilter has been applied on this sheet. <Dimension> indicates the used range on this sheet. There should be no data or formulas outside this range. The <sheetViews> collection indicates which cell is active on the sheet, and indicates whether this particular sheet is the active sheet in the workbook.

A collection of column-level settings appears in the <cols> collection.

Finally, within <sheetFormatPr>, a default row height is set.