c# 将Datatable数据导出到Excel表格中

本文主要介绍了c# 将Datatable数据导出到Excel表格中的方法。具有很好的参考价值。下面跟着小编一起来看下吧

话不多说，请看代码：

				?

									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"); 

									      }

									    }