Spread 8.0 Documentation
DeleteSheets Method
Support Options
ActiveX Reference > ActiveX Methods > DeleteSheets Method

Glossary Item Box

DeleteSheets Method


See Also    DLL    Example

Applies To

fpSpread control

Description

Deletes the specified sheet or sheets.

Syntax

C++

BOOL CSpreadSheet::DeleteSheets(short SheetIndex, short SheetCnt);

Visual Basic

fpSpread1.DeleteSheets(ByVal SheetIndex As Integer, ByVal SheetCnt As Integer) As Boolean

Parameters

The following parameters are available:

Parameter Description
SheetIndex Sheet index of first sheet to delete
SheetCnt Number of sheets to delete

Remarks

Deleting sheets changes the number of sheets in the control, as reflected by the SheetCount property.

If the SheetCount property is one and DeleteSheets is used then the sheet will be deleted and a new sheet will be added.

Return Type

True if the sheets are deleted successfully; false otherwise.

See Also

Deleting Sheets

SheetCount property

InsertSheets, MoveSheets methods

DLL Correspondence

SSDeleteSheets function

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