C # export Datatable data to an Excel table,
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 () + "test document (" + bdate. trim () + "-" + lldate. trim () + "2.16.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", "Test Documents (" + qua_no.Trim () + "..xls ");
}
}