Spread 8.0 Documentation
SheetCount Property
Support Options
ActiveX Reference > ActiveX Properties > SheetCount Property

Glossary Item Box

SheetCount Property


See Also    DLL    Example

Applies To

fpSpread control

Description

Sets or returns the number of sheets in the workbook.

Syntax

C++

short CSpreadSheet::GetSheetCount( )
void CSpreadSheet::SetSheetCount(short value)

Visual Basic

[form.]fpSpread.SheetCount[ = value%]

Remarks

The default value for the SheetCount property is 1 sheet. The maximum allowed value for the SheetCount property is 1000.

Caution: If the workbook contains more than one sheet, and you reduce the sheet count, sheets will be deleted from the workbook. For example, if you change the SheetCount property value from 6 to 4, sheets 5 and 6 will be deleted from the workbook.

If the workbook contains more than one sheet, specify the sheet with which to interact by setting the ActiveSheet or Sheet property. Specify the name for a sheet by setting the SheetName property.

Spread Designer

Choose the Book menu, then the Sheet and Tab menu, select the Sheet and Tab tab, and type or select the number in the Sheet Count spin control in the Book Settings dialog box.

Data Type

Integer

See Also

ActiveSheet, Sheet, SheetName properties

DLL Correspondence

SSGetSheetCount, SSSetSheetCount functions

© 2002-2014 ComponentOne, a division of GrapeCity. All Rights Reserved.