<dimension> (Worksheet Dimensions)

This element specifies the used range of the worksheet. It specifies the row and column bounds of used cells in the worksheet. This is optional and is not required. Used cells include cells with formulas, text content, and cell formatting. When an entire column is formatted, only the first cell in that column is considered used.

example: 
<dimension ref="A1:C2"/>

Parent Elements

<worksheet> (§3.3.1.96)

Attributes

Description

<ref> (Reference)

The row and column bounds of all cells in this worksheet. Corresponds to the range that would contain all <c> elements written under <sheetData>. Does not support whole column or whole row reference notation.

The possible values for this attribute are defined by the ST_Ref simple type (§3.18.64).

The following XML Schema fragment defines the contents of this element:

<complexType name="CT_SheetDimension">
	<attribute name="ref" type="ST_Ref" use="required"/>
</complexType>