Sheet columns

Definition of Sheet columns

Use the Columns collection to define properties for table columns.

The collection does not require adding columns to define the list of columns. Columns in a collection are created automatically when accessing collection items.

For example the code:

Sheet.Columns[5].Width := 20;

Creates a list of five columns in the collection (if they are not already in the collection) and assigns the heel of the column a width of 20 Width Units. Column numbering in the collection starts from zero.

The size of the unit column width in Excel is set according to the following rule:

Column width measured as the number of characters of the maximum digit width of the numbers 0, 1, 2, …, 9 as rendered in the normal style's font. There are 4 pixels of margin padding (two on each side), plus 1 pixel padding for the gridlines.

Use TXlsFileColumnsEh.ScreenToXlsWidth function to convert screen column width to width in Excel units.

Sheet.Columns[1].Width := Sheet.Columns.ScreenToXlsWidth(DBGridEh1.Columns[1].Width);

The Sheet.Columns collection contains objects of type TXlsFileColumnEh.

TXlsFileColumnEh class contains the following properties:

property OutlineLevel: Integer;

Grouping level. The property is used when grouping columns in a table. If column does not participate in the grouping, then the value contains 0.

property OutlineNodeCollapsed;

The group header is collapsed. The property is used when grouping columns in a table. If the column is a group header and the group is collapsed, then the property contains True. Columns that are in a collapsed group also need to set the Visible property to False.

property Width: Double;

Column width in Excel units of width.

property Visible: Boolean;

The column is visible.