Dokumentacija HotXLS Vsebina Domov Pregled TGridToXLS IXLSWorkbook Domov Vsebina Pregled

Rows lastnost

Vrne a vmesnik IXLSRowsRange to TXLSRange object that represents the rows in the specified range. Read only IXLSRowsRange

Skladnja

property Rows: IXLSRowsRange;

Primer

This example sets the font style in the second row of range A1:F10 to bold
With Workbook.Sheets[1].Range['A1', 'F10'] do begin Rows[2].Font.Bold := True; end; This example copies the values from the second row of range A1:F10 to third
With Workbook.Sheets[1].Range['A1', 'F10'] do begin Rows[3].Value := Rows[2].Value; end; This example displays the number of rows in the selection on sheet one
MessageDlg('The selection contains ' + inttostr(Workbook.Worksheets[1].Selection.Rows.Count) + ' rows.', mtInformation, [mbOk], 0); Copyright © 2010-2026 losLab Software