HotXLS Docs
Main Index Overview

Referring to cells and ranges using A1 notation

You can refer to a cell or range of cells in the A1 reference style by using the Range property

Example

The ensuing example changes the format of cells A1:D5 to bold 
Workbook.Sheets[1].Range['A1','D5'].Font.Bold := true;
The ensuing example changes the value of cell B3 to 100 
Workbook.Sheets[1].Range['B3','B3'].Value := 100;
The ensuing example merges the cells B2:C5 
Workbook.Sheets[1].Range['B2','C5'].Merge(False);