Deleting Excel WorkSheet using C#
You can delete any worksheet from Microsoft Excel file. In order to delete a worksheet, you must add a reference to the Microsoft.Office.Interop.Excel assembly, and then you must use classes from that assembly to open a workbook and delete a worksheet.The following program shows how to delete worksheet from an an existing Excel file using C#.
To access the object model from Visual C# .NET, you have to add the Microsoft Excel 12.0 Object Library to you project. In the previous chapter you can see a step by step instruction on how to add Excel library to your project.How to add Excel Library
Delete worksheet from an excel file
In order to delete worksheet from excel file, this program open an existing Excel file and select the worksheet and then delete it.
Delete Excel.Worksheet without prompts
DisplayAlerts set to False for suppress prompts and alert messages while a macro is running. When a message need a response from the end user, Microsoft Excel chooses the default response. After you complete the running process, Microsoft Excel sets this property to True, unless you are running cross-process code.
The following source code shows how to programmatically delete Worksheets from Workbooks.