Dokumentacija HotXLS

Referring to Ranges by using Index numbers

You can use the RCRange property to refer to a range of cells by using row and column index numbers

Primjer

The following example changes the format of cells A1:D5 to bold
Workbook.Sheets[1].RCRange[1, 1, 5, 4].Font.Bold := true;
Sljedeći primjer mijenja vrijednost ćelije B3 u 100
Workbook.Sheets[1].RCRange[3, 2, 3, 2].Value := 100;
Sljedeći primjer spaja ćelije B2:C5
Workbook.Sheets[1].RCRange[2, 2, 5, 3].Merge(False);