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 AM

This 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 Tags

Notepad++7.3.1

Notepad++7.3.1

Easy-to-use and free code editor

SublimeText3 Chinese version

SublimeText3 Chinese version

Chinese version, very easy to use

Zend Studio 13.0.1

Zend Studio 13.0.1

Powerful PHP integrated development environment

Dreamweaver CS6

Dreamweaver CS6

Visual web development tools

SublimeText3 Mac version

SublimeText3 Mac version

God-level code editing software (SublimeText3)

Active Directory with C# Active Directory with C# Sep 03, 2024 pm 03:33 PM

Active Directory with C#

Access Modifiers in C# Access Modifiers in C# Sep 03, 2024 pm 03:24 PM

Access Modifiers in C#

Random Number Generator in C# Random Number Generator in C# Sep 03, 2024 pm 03:34 PM

Random Number Generator in C#

C# Data Grid View C# Data Grid View Sep 03, 2024 pm 03:32 PM

C# Data Grid View

Patterns in C# Patterns in C# Sep 03, 2024 pm 03:33 PM

Patterns in C#

C# StringReader C# StringReader Sep 03, 2024 pm 03:23 PM

C# StringReader

BinaryWriter in C# BinaryWriter in C# Sep 03, 2024 pm 03:22 PM

BinaryWriter in C#

C# StringWriter C# StringWriter Sep 03, 2024 pm 03:23 PM

C# StringWriter

See all articles