Programmatically delete worksheets from workbooks

You can delete any worksheet in a workbook. To delete a worksheet, use the worksheet host item or access the worksheet by using the sheets collection of the workbook.

Applies to: The information in this topic applies to document-level projects and VSTO Add-in projects for Excel. For more information, see Features available by Office application and project type.

If the worksheet was added at design-time in a document-level customization, use the Delete method to delete a specified worksheet. The following code deletes a worksheet from a workbook by referencing the worksheet host item directly.

1. Call the Delete method of Sheet1.

   • C#
   • VB

   Globals.Sheet1.Delete();
   

Access worksheets through the Microsoft Office Excel Sheets collection in the following cases:

• You want to delete a worksheet in a VSTO Add-in.

• The worksheet that you want to delete was created at run time in a document-level customization.

  The following code deletes a worksheet from a workbook by referencing the sheet through the index number of the Sheets collection. This code assumes that a new worksheet was created programmatically.

1. Call the Delete method of the Sheets collection.

   • C#
   • VB

   ((Excel.Worksheet)this.Application.ActiveWorkbook.Sheets[4]).Delete();
   

• Work with worksheets
• How to: Programmatically hide worksheets
• How to: Programmatically move worksheets within workbooks
• How to: Programmatically select worksheets
• How to: Programmatically add new worksheets to workbooks
• Worksheet host item
• Global access to objects in Office projects
• Programmatic limitations of host items and host controls