Multiple sheets in a excel workbook

Question

Hi How to create multiple sheets in excel workbook by c# code. Darma

darma teja · Answer

Hi Still i am getting error. here is my code: I want to get 10 sheets in a excel file. Microsoft.Office.Interop.Excel.Application app = new Microsoft.Office.Interop.Excel.Application(); Workbooks wbks = app.Workbooks; _Workbook _wbk = wbks.Add(true); Sheets shs = _wbk.Sheets; for (int i = 1; i { _Worksheet _wsh = (_Worksheet)shs.get_Item(i); }

George eric · Answer

Hi If you use Microsoft.Office.Interop.Excel; It will be quite simple for you to manage Excel in C#. See my link: http://www.codeproject.com/Articles/198572/Summarize-C-Control-Excel-Skills