HotXLS Documentation

Item property

Returns a IXLSRange object that represents a range at an offset from the specified range

Syntax

property Item[Row: Word; Col: Word]: IXLSRange;
Row Word. A number that indicates the row number of the cell you want to access, starting with 1 for the first row in the range
Col Word. A number that indicates the column number of the cell you want to access, starting with 1 for the first column in the range

Example

This example sets the value of the first cell in selection to 3.14

Workbook.Sheets[1].Selection.Item[1, 1].Value := 3.14;