c#导出数据到多个sheet表

region 导出到excel多sheet
        private void ToExcelSheet(DataSet ds,string sheetName)
        {
            int testnum = ds.Tables.Count-1;

            Excel.Application appExcel;
            appExcel = new Excel.Application();
           
            Excel.Workbook workbookData;
            Excel.Worksheet worksheetData;

            workbookData = appExcel.Workbooks.Add(Missing.Value);
            //
            //workbookData.Worksheets.Delete();
            for(int k=0;k<ds.Tables.Count;k++)
            {
                worksheetData = (Excel.Worksheet)workbookData.Worksheets.Add(Missing.Value,Missing.Value,Missing.Value,Missing.Value);
                worksheetData.Name = sheetName+"_"+testnum.ToString();
                testnum--;
                if(ds.Tables[k]!=null)
                {
                    for(int i=0;i<ds.Tables[k].Rows.Count;i++)
                    {
                        for(int j=0;j<ds.Tables[k].Columns.Count;j++)
                        {
                            worksheetData.Cells[i+1,j+1] = ds.Tables[k].Rows[i][j].ToString();
                        }
                    }
                }
               
                worksheetData.Columns.EntireColumn.AutoFit();
                workbookData.Saved = true;

            }
            //string strFileName = "C://Inetpub//wwwroot//External//Mongoose//files//"+ sheetName + ".xls";
            string strFileName = "e://www//页面//External//Mongoose//files//"+ sheetName + ".xls";
           
            workbookData.SaveCopyAs(strFileName);

            appExcel.Quit();

            Response.Redirect("../Mongoose/files/"+sheetName+".xls");

        }
           
        #endregion