HotXLS-dokumentaatio
Sisältö
Etusivu
Yleiskatsaus
TGridToXLS
IXLSWorkbook
Etusivu
Sisältö
Yleiskatsaus
Columns ominaisuus
Palauttaa an rajapinta IXLSColsRange to TXLSRange object that represents the columns in the specified range. Read-only
Syntaksi
property Columns: IXLSColsRange;
Esimerkki
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