Add new worksheet in Excel file
It is possible to dynamically insert a worksheet into an existing Excel file and subsequently include it within the collection of worksheets. The program provided below exemplifies the process of adding a new worksheet to an already established Excel workbook.
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
programmatically Add New Worksheets to Workbooks
In order to add new worksheet to the excel file, this program open an existing Excel file and add a new worksheet in the existing excel file.
Add Excel Worksheet without prompts
To disable the Excel overwrite prompt and suppress prompts and alert messages during the execution of a macro, you can incorporate the following code. By setting the DisplayAlerts property to False, you can prevent Excel from displaying prompts that require user response. In situations where user input is required, Microsoft Excel will proceed with the default response. Following the completion of the execution process, Microsoft Excel automatically resets the DisplayAlerts property to True, unless cross-process code is being executed.
Programmatically Select Worksheets
You can Programmatically select Worksheet and set focus on that worksheet when user open the Excel document.
Above method shows how to select a specified worksheet, in this way you can select any existing worksheet in an Excel document.releaseObject()
Finally, we have to properly clean up Excel interop objects or release Excel COM objects. Here using a function releaseObject() to clean up the Excel object properly.
The following source code shows how to insert new worksheet in an excel fileFull Source C#