Columns property

Returns an IXLSColsRange Interface to TXLSRange object that represents the columns in the specified range. Read-only.

Syntax

property Columns: IXLSColsRange;

Example

This example sets the font style in the second column of range A1:F10 to bold.

With Workbook.Sheets[1].Range['A1', 'F10'] do begin
  Columns[2].Font.Bold := True; 
end;

This example copies the values from the second column of range A1:F10 to third.

With Workbook.Sheets[1].Range['A1', 'F10'] do begin
  Columns[3].Value := Columns[2].Value; 
end;

This example displays the number of columns in the selection on sheet one.

MessageDlg('The selection contains ' +
           inttostr(Workbook.Worksheets[1].Selection.Columns.Count) + ' columns.',
           mtInformation, [mbOk], 0);