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
c#导出数据到多个sheet表
最新推荐文章于 2022-09-01 08:57:32 发布