Loading

Multiple sheets in a excel workbook

darma teja

Hi,

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

Darma

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

darma teja14y ago
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 < 10; i++)
{
_Worksheet _wsh = (_Worksheet)shs.get_Item(i);
}
0
George eric14y ago
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
0