TdxCustomSpreadSheet.ClearAll Method

Deletes all worksheets in the opened spreadsheet document.

Declaration

procedure ClearAll;

Remarks

Call this procedure to delete all worksheets simultaneously. To delete an individual worksheet, call its destructor.

A user can click the “Delete” item in the caption bar‘s context menu or execute the DeleteSheet command to delete the active sheet if at least two sheets are visible. Spreadsheet controls provide no commands or built-in UI elements that allow users to remove all sheets from the document.