C# WITH EXCEL

Question

how to create multiple worksheet in already existing workbook in excel using c#.net. i have excel file in local folder . default 3 sheet how to create more the 3 sheet in excel using c#.NET.KINDLY SEND CODE

Nishant Mittal · Answer

Hi.. Hope this will help :) http://csharp.net-informations.com/excel/worksheet.htm

Lisa White · Answer

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