C # sample code sharing for exporting DataTable data to an Excel table

This article mainly describes how C # exports DataTable data to Excel tables. Has a good reference value. Let's take a look at the little series.

If you don't say much, look at the code:

Public Fileresult Getexcelfile () {if (session["begindate"]! = null) {string bdate = session["Beginda TE "].        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 () + "). 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", "Lab document" + Qua_no.       Trim () + "). xls"); }    }