<cols> (Column Information)

Information about whole columns of the worksheet.

example:

This example shows that column 4 (D) has 'best fit' applied to it, which is also a custom width. Also, column 5 (E) is listed as having a custom width and a style applied at the column level (as opposed to the cell level).

<cols>
  <col min="4" max="4" width="12" bestFit="1" customWidth="1"/>
  <col min="5" max="5" width="9.140625" style="3"/>
</cols>

Parent Elements

<worksheet> (§3.3.1.96)

Child Elements

Subclause

<col> (Column Width & Formatting)

§3.3.1.12

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

<complexType name="CT_Cols">
	<sequence>
	<element name="col" type="CT_Col" minOccurs="1" maxOccurs="unbounded"/>
	</sequence>
</complexType>