Home
Backend Development
C#.Net Tutorial
c# Sample code sharing for exporting Datatable data to Excel table



c# Sample code sharing for exporting Datatable data to Excel table
Mar 24, 2017 am 11:19 AMThis article mainly introduces the method of c# exporting Datatable data to Excelsheet. Has very good reference value. Let’s take a look with the editor below
Without further ado, please look at the code:
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() + "化验单据(" + 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"); } }
Copy after login
The above is the detailed content of c# Sample code sharing for exporting Datatable data to Excel table. For more information, please follow other related articles on the PHP Chinese website!
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn

Hot Article
Repo: How To Revive Teammates
3 weeks ago
By 尊渡假赌尊渡假赌尊渡假赌
How Long Does It Take To Beat Split Fiction?
3 weeks ago
By DDD
Hello Kitty Island Adventure: How To Get Giant Seeds
3 weeks ago
By 尊渡假赌尊渡假赌尊渡假赌
R.E.P.O. Energy Crystals Explained and What They Do (Yellow Crystal)
1 weeks ago
By 尊渡假赌尊渡假赌尊渡假赌

Hot tools Tags

Hot Article
Repo: How To Revive Teammates
3 weeks ago
By 尊渡假赌尊渡假赌尊渡假赌
How Long Does It Take To Beat Split Fiction?
3 weeks ago
By DDD
Hello Kitty Island Adventure: How To Get Giant Seeds
3 weeks ago
By 尊渡假赌尊渡假赌尊渡假赌
R.E.P.O. Energy Crystals Explained and What They Do (Yellow Crystal)
1 weeks ago
By 尊渡假赌尊渡假赌尊渡假赌

Hot Article Tags

Notepad++7.3.1
Easy-to-use and free code editor

SublimeText3 Chinese version
Chinese version, very easy to use

Zend Studio 13.0.1
Powerful PHP integrated development environment

Dreamweaver CS6
Visual web development tools

SublimeText3 Mac version
God-level code editing software (SublimeText3)
