SheetCount Property
Applies To
fpSpread control
Description
Sets or returns the number of sheets in the workbook.
Syntax
short CSpreadSheet::GetSheetCount( )
void CSpreadSheet::SetSheetCount(short value)
[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