[测速]c# 将Datatable数据导出到Excel表格中

【www.bbyears.com--excel】

   代码如下 publicFileResult GetExcelFile()    {      if(Session["beginDate"] !=null)      {        stringbdate = Session["beginDate"].ToString();        DateTime ld = Convert.ToDateTime(Session["lastDate"].ToString());        DateTime ldate = ld.AddDays(1);        stringlldate = ldate.ToString("yyyy-MM-dd");        intptkey = Convert.ToInt32(Session["Process_PTR"]);        stringproceSql ="select * from Assay_Process where RKEY="+ptkey;        DataTable proceDt = SqlHelper.QueryTable(proceSql);        IDataParameter[] iDataTitle =newSqlParameter[3];        iDataTitle[0] =newSqlParameter("@BeginDate", bdate);        iDataTitle[1] =newSqlParameter("@LastDate", lldate);        iDataTitle[2] =newSqlParameter("@RKEY", ptkey);        DataSet dtTitle = SqlHelper.RunProceduresByParameter("pro_GetAssalyInfoByExportPrint", iDataTitle);        DataTable dt = 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);        DataSet dtTitle = SqlHelper.RunProceduresByParameter("pro_GetAssalyInfoByQua_No", iDataTitle);        DataTable dt = dtTitle.Tables[0];        stringoutStr = ExcelExport.outExcel(dt);        byte[] fileContents = Encoding.UTF8.GetBytes(outStr.ToString());        returnFile(fileContents,"application/ms-excel","化验单据("+ qua_no.Trim()+").xls");      }    } 

本文来源：http://www.bbyears.com/bangongshuma/133962.html