SSGetSheetCount, SSSetSheetCount Functions
Applies To
fpSpread DLL control
Description
Set or return the number of sheets in the workbook.
Syntax
C
short SSGetSheetCount(HWND hWnd);
BOOL SSSetSheetCount(HWND hWnd, short nSheetCnt);
C++
short TSpread::GetSheetCount( );
BOOL TSpread::SetSheetCount(short nSheetCnt);
Parameters
The SSGetSheetCount function has the following parameter:
| Parameter | Description |
| hWnd | Window handle of the fpSpread control |
The SSSetSheetCount function has the following parameters:
| Parameter | Description |
| hWnd | Window handle of the fpSpread control |
| nSheetCount | Number of sheets in the workbook |
Remarks
The value can be any value from 1 through 1000. You can change the number of sheets at any time.
| Caution: If you decrease the number of sheets, any data or formats in the sheets beyond the new setting are lost. |
Return Value
SSGetSheetCount: Number of sheets in the workbook.
SSSetSheetCount: TRUE if the function completes successfully; FALSE otherwise.
See Also
SSGetSheet, SSGetSheetName, SSSetSheet, SSSetSheetName functions
ActiveX Correspondence
SheetCount property