最新下载
热门教程
- 1
- 2
- 3
- 4
- 5
- 6
- 7
- 8
- 9
- 10
c# 将Datatable数据导出到Excel表格中
时间：2022-06-25 07:49:42 编辑：袖梨 来源：一聚教程网
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"]); 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"); } }相关文章
- 王者荣耀侦探能力大测试攻略 王者荣耀侦探能力大测试怎么过 11-22
- 无期迷途主线前瞻兑换码是什么 11-22
- 原神欧洛伦怎么培养 11-22
- 炉石传说网易云音乐联动怎么玩 11-22
- 永劫无间手游确幸转盘怎么样 11-22
- 无期迷途主线前瞻兑换码是什么 无期迷途主线前瞻直播兑换码介绍 11-22