HotXLS Docs
Home Contents Overview

Cells property

Returns a IXLSRange object that represents all the cells on the Worksheet (not just the cells that are currently in use). Read-only.

Syntax

property Cells: IXLSRange;

Example

This example sets the font size for cell A3 on first sheet to 10 pointers. 

Workbook.Sheets[1].Cells.Item[1,3].Font.Size := 10;
This example sets the font and font size for every cell on first sheet to 11-pointer Arial. 

With Workbook.Sheets[1].Cells.Font do
begin
  Name := 'Arial';
  Size := 11;
end;