SSGetSheetCount, SSSetSheetCount Functions

---

See Also    ActiveX    Example

Applies To

fpSpread DLL control

Description

Set or return the number of sheets in the workbook.

Syntax

short SSGetSheetCount(HWND hWnd);

BOOL SSSetSheetCount(HWND hWnd, short nSheetCnt);

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

Adding Sheets

SSGetSheet, SSGetSheetName, SSSetSheet, SSSetSheetName functions

ActiveX Correspondence

SheetCount property