Returns a IXLSRowsRange interface to TXLSRange object that represents the rows in the specified range. Read only IXLSRowsRange.
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);
