c# winform中,datatable导入excel问题...急

[yilee]

导入到excel的一个sheet1已经实现了.代码如下:
int i, j;
Excel.ApplicationClass my = new Excel.ApplicationClass();
my.Visible = false;
object objMissing = System.Reflection.Missing.Value;


Excel.Workbook mybook = (Excel.Workbook)my.Workbooks.Add(1);
((Excel.Worksheet)mybook.Worksheets[1]).Name = "sheet1";
Excel.Worksheet mysheet = (Excel.Worksheet)mybook.Worksheets[1];
for (i = 0; i < dt3.Rows.Count; i++)
{
for (j = 0; j < dt3.Columns.Count; j++)
mysheet.Cells[i + 1, j + 1] = dt3.Rows[i][j];
}
mybook.SaveAs("e:\\aa.xls", objMissing, objMissing, objMissing, objMissing, objMissing, Excel.XlSaveAsAccessMode.xlShared, objMissing, objMissing, objMissing, objMissing, objMissing);
mybook = null;
my.Quit();
my = null;
现在的问题是我想在一个excel里面导入多个datatable,分别存为sheet1,sheet2,sheet3....
请教各位高手,这个该怎么实现...(是winform不是网页).

[yilee]

我自己解决了分都没人要吗?
顶一下就给分啊...不然就浪费了...

[chenxu4277]

问题不大会，分我要了

[DotGod]

up

[yilee]

结贴了~~给分了~~谢谢支持~~

[windykuang]

怎么解决的啊？分享下我给你50分.