Reference>IXLSWorksheet>Cells

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;

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

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-point Arial.

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