话不多说，请看代码：
public FileResult GetExcelFile()
{
if (Session[ "beginDate" ] != null )
{
string bdate = Session[ "beginDate" ].ToString();
DateTime ld = Convert.ToDateTime(Session[ "lastDate" ].ToString());
DateTime ldate = ld.AddDays(1);
string lldate = ldate.ToString( "yyyy-MM-dd" );
int ptkey = Convert.ToInt32(Session[ "Process_PTR" ]);
string proceSql = "select * from Assay_Process where RKEY=" +ptkey;
DataTable proceDt = SqlHelper.QueryTable(proceSql);
IDataParameter[] iDataTitle = new SqlParameter[3];
iDataTitle[0] = new SqlParameter( "@BeginDate" , bdate);
iDataTitle[1] = new SqlParameter( "@LastDate" , lldate);
iDataTitle[2] = new SqlParameter( "@RKEY" , ptkey);
DataSet dtTitle = SqlHelper.RunProceduresByParameter( "pro_GetAssalyInfoByExportPrint" , iDataTitle);
DataTable dt = dtTitle.Tables[0];
string outStr = ExcelExport.outExcel(dt);
byte [] fileContents = Encoding.UTF8.GetBytes(outStr.ToString());
return File(fileContents, "application/ms-excel" , "" + proceDt.Rows[0][ "ProcessName" ].ToString().Trim() + "化验单据(" + bdate.Trim() + "-" + lldate.Trim() + ").xls" );
}
else
{
string qua_no = Session[ "quano" ].ToString();
IDataParameter[] iDataTitle = new SqlParameter[1];
iDataTitle[0] = new SqlParameter( "@Qua_no" , qua_no);
DataSet dtTitle = SqlHelper.RunProceduresByParameter( "pro_GetAssalyInfoByQua_No" , iDataTitle);
DataTable dt = dtTitle.Tables[0];
string outStr = ExcelExport.outExcel(dt);
byte [] fileContents = Encoding.UTF8.GetBytes(outStr.ToString());
return File(fileContents, "application/ms-excel" , "化验单据(" + qua_no.Trim()+ ").xls" );
}
}
以上就是本文的全部内容，希望本文的内容对大家的学习或者工作能带来一定的帮助，同时也希望多多支持服务器之家！
原文链接：http://HdhCmsTestcnblogs测试数据/Resources-blogs/p/6600913.html
dy("nrwz");
查看更多关于c# 将Datatable数据导出到Excel表格中的详细内容...