c# 将Datatable数据导出到Excel表格中
话不多说，请看代码：
publicFileResultGetExcelFile()
{
if(Session["beginDate"]!=null)
{
stringbdate=Session["beginDate"].ToString();
DateTimeld=Convert.ToDateTime(Session["lastDate"].ToString());
DateTimeldate=ld.AddDays(1);
stringlldate=ldate.ToString("yyyy-MM-dd");
intptkey=Convert.ToInt32(Session["Process_PTR"]);
stringproceSql="select*fromAssay_ProcesswhereRKEY="+ptkey;
DataTableproceDt=SqlHelper.QueryTable(proceSql);
IDataParameter[]iDataTitle=newSqlParameter[3];
iDataTitle[0]=newSqlParameter("@BeginDate",bdate);
iDataTitle[1]=newSqlParameter("@LastDate",lldate);
iDataTitle[2]=newSqlParameter("@RKEY",ptkey);
DataSetdtTitle=SqlHelper.RunProceduresByParameter("pro_GetAssalyInfoByExportPrint",iDataTitle);
DataTabledt=dtTitle.Tables[0];
stringoutStr=ExcelExport.outExcel(dt);
byte[]fileContents=Encoding.UTF8.GetBytes(outStr.ToString());
returnFile(fileContents,"application/ms-excel",""+proceDt.Rows[0]["ProcessName"].ToString().Trim()+"化验单据("+bdate.Trim()+"-"+lldate.Trim()+").xls");
}
else
{
stringqua_no=Session["quano"].ToString();
IDataParameter[]iDataTitle=newSqlParameter[1];
iDataTitle[0]=newSqlParameter("@Qua_no",qua_no);
DataSetdtTitle=SqlHelper.RunProceduresByParameter("pro_GetAssalyInfoByQua_No",iDataTitle);
DataTabledt=dtTitle.Tables[0];
stringoutStr=ExcelExport.outExcel(dt);
byte[]fileContents=Encoding.UTF8.GetBytes(outStr.ToString());
returnFile(fileContents,"application/ms-excel","化验单据("+qua_no.Trim()+").xls");
}
}
以上就是本文的全部内容，希望本文的内容对大家的学习或者工作能带来一定的帮助，同时也希望多多支持毛票票！