<cols> (Column Information)

Information about whole columns of the worksheet.


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).

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

Parent Elements


Child Elements


<col> (Column Width & Formatting)


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

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