HotXLS Docs
Home Contents Overview

Count property

Returns the number of sheets in the Worksheets collection. Read-only Integer.

Syntax

property Count: Integer;

Example

This example uses the Count property to set the value of A1 cell on the first sheet. 

Workbook.Sheets[1].Range['A1','A1'].Value := Workbook.Sheets.Count;