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

时间：2017-07-24 编辑：简简单单来源：一聚教程网

代码如下

复制代码

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

上一个： c# 将Datatable数据导出到Excel表格中
下一个： c#读取XML多级子节点

推荐专题

最新下载

热门教程

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

相关文章

热门栏目

php教程

asp.net教程

手机开发

css教程

网页制作

办公数码

jsp教程