HotXLS Delphi Excel Read Write Library / Component Developers Guide loslab Inc.

RCRange property

Returns a Range object that represents a cell or a range of cells.

Syntax

property RCRange[Row1, Col1, Row2, Col2: Integer]: IXLSRange;
Row1 Integer. A number that indicates the first row of the range, starting with 1 for the first row in the Worksheet.
Col1 Integer. A number that indicates the first column of the range, starting with 1 for the first column in the Worksheet.
Row2 Integer. A number that indicates the last row of the range, starting with 1 for the first row in the Worksheet.
Col2 Integer. A number that indicates the last column of the range, starting with 1 for the first column in the Worksheet.

Example

This example sets the font style in cells A1:D10 on the first sheet to bold.

Workbook.Sheets[1].RCRange[1, 1, 10, 4].Font.Bold := True;
Copyright©2014 loslab.com