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

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;
Copyright©2014 loslab.com