C# WITH EXCEL

hi kumar yoga,

According to your description, you want to insert new worksheets to an existing excel workbook, then you could use Spire.XLS to achieve this easily, refer the following code snippet:

static void Main(string[] args)

{

Workbook workbook = new Workbook();

workbook.LoadFromFile("Information.xlsx");

workbook.Worksheets.Add("sheet4");

workbook.Worksheets.Add("sheet5");

workbook.SaveToFile("Addworksheet.xlsx");

}

Available here:

http://www.e-iceblue.com/Introduce/free-xls-component.html

if you want to create a new workbook with worksheets more than 3, refer this:

http://www.e-iceblue.com/Tutorials/Spire.XLS/Spire.XLS-Program-Guide/Add-Excel-Worksheet-in-C-/VB.NET.html