Delete worksheet from an excel - VB.Net
By default, Excel provides three worksheets in a workbook, but you can add new worksheets or delete worksheets as needed programmatically from VB.Net application. 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 VB.Net program shows how to delete worksheet from an an existing Excel file.
To access the object model from Visual VB.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 VB.Net 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 user side, Microsoft Excel chooses the default response. After you finish the running process, Microsoft Excel sets this property to True, unless you are running cross-process code.
The following VB.Net source code shows how to programmatically delete Worksheets from Workbooks.