HotXLS Belgeleri İçindekiler Ana sayfa Genel bakış TGridToXLS IXLSWorkbook Ana sayfa İçindekiler Genel bakış

Columns özellik

Döndürür an arayüzü IXLSColsRange to TXLSRange object that represents the columns in the specified range. Read-only

Sözdizimi

property Columns: IXLSColsRange;

Örnek

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); Copyright © 2010-2026 losLab Software