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

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 following example changes the format of cells A1:D5 to bold.
Workbook.Sheets[1].Range['A1','D5'].Font.Bold := true;
The following example changes the value of cell B3 to 100.
Workbook.Sheets[1].Range['B3','B3'].Value := 100;
The following example merges the cells B2:C5.
Workbook.Sheets[1].Range['B2','C5'].Merge(False);
Copyright©2007-2019 loslab.com