How to: Delete a Worksheet

• Sep 19, 2023

Important

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use these examples in production code.

This example demonstrates how to remove a worksheet from a workbook by calling the WorksheetCollection.Remove or WorksheetCollection.RemoveAt method of the WorksheetCollection object that is accessed via the Workbook.Worksheets property.

View Example

WorksheetActions.cs

// Delete the "Sheet2" worksheet from the workbook.
workbook.Worksheets.Remove(workbook.Worksheets["Sheet2"]);

// Delete the first worksheet from the workbook.
workbook.Worksheets.RemoveAt(0);

WorksheetActions.vb

' Delete the "Sheet2" worksheet from the workbook.
workbook.Worksheets.Remove(workbook.Worksheets("Sheet2"))

' Delete the first worksheet from the workbook.
workbook.Worksheets.RemoveAt(0)

You can also hide a worksheet. See the How to: Show and Hide a Worksheet topic for details.

Note

A workbook must always contain at least one visible worksheet.