一个excel中导出多个sheet的问题

[湖中仙人]

我在一个excel中导出4个excel时出现无效索引的提示,好像是因为大于默认的3个sheet了请问这个问题如何解决?
Interop.Excel.Application xlApp;
Interop.Excel.Workbook xlBook;
Interop.Excel.Worksheet xlSheet1;
Interop.Excel.Worksheet xlSheet2;
Interop.Excel.Worksheet xlSheet3;
Interop.Excel.Worksheet xlSheet4;

xlApp = CreateObject("Excel.Application");

xlBook = xlApp.Workbooks.Add;

MessageBox.Show(xlBook.Sheets.Count.ToString());
xlSheet1 = CType(xlBook.Worksheets(1), Microsoft.Office.Interop.Excel.Worksheet);
xlBook.Sheet.Add(xlSheet1);
xlSheet2 = CType(xlBook.Worksheets(2), Microsoft.Office.Interop.Excel.Worksheet);
xlBook.Sheet.Add(xlSheet2);
xlSheet3 = CType(xlBook.Worksheets(3), Microsoft.Office.Interop.Excel.Worksheet);
xlBook.Sheet.Add(xlSheet3);
xlSheet4 = CType(xlBook.Worksheets(4), Microsoft.Office.Interop.Excel.Worksheet);
xlBook.Sheet.Add(xlSheet4);

[湖中仙人]

我改成下面这样为什么还是提示是4个,而不是6个呢??
Interop.Excel.Application xlApp;
Interop.Excel.Workbook xlBook;
Interop.Excel.Worksheet xlSheet1;
Interop.Excel.Worksheet xlSheet2 ;
Interop.Excel.Worksheet xlSheet3;
Interop.Excel.Worksheet xlSheet4;
Interop.Excel.Worksheet Sheet1;
Interop.Excel.Worksheet Sheet2;
xlApp = CreateObject("Excel.Application");

xlBook = xlApp.Workbooks.Add;
xlBook.Worksheets.Add();
MessageBox.Show(xlBook.Worksheets.Count.ToString());

[RexZheng]

需要发那么多贴吗？

http://topic.csdn.net/u/20081128/10/77d7e494-a528-4e58-ae3b-aca46bf487a6.html

[wangkk125]

关注中

[cpio]

xlBook.AddSheet(可能叫这个名字，也可能号Inert之类)可以添加Sheet

由于默认只有3个Sheet，所以引用第4个会出错

[yilanwuyu123]

mark 看能不能通过代码增加一个sheet

[路人乙e]

Excel.Worksheet newWorksheet;
newWorksheet = (Excel.Worksheet)Globals.ThisWorkbook.Worksheets.Add(missing, missing, missing, missing);

[湖中仙人]

加一个sheet的代码是怎样的??