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>

end example]

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>