C# -使用HttpContext格式的单元格值将dataTable导出到Excel

using System;
using System.Data;
using System.Web;
using System.Web.UI.WebControls;
using System.IO;
using System.Web.UI;

public partial class ExportToExcel : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            DataTable dataTable = GetDataTable(); // 获取要导出的数据表

            Response.Clear();
            Response.Buffer = true;
            Response.AddHeader("content-disposition", "attachment;filename=ExportedData.xls");
            Response.Charset = "";
            Response.ContentType = "application/vnd.ms-excel";
            StringWriter stringWriter = new StringWriter();
            HtmlTextWriter htmlTextWriter = new HtmlTextWriter(stringWriter);

            // 创建一个GridView控件，并将数据绑定到GridView
            GridView gridView = new GridView();
            gridView.DataSource = dataTable;
            gridView.DataBind();
            gridView.RenderControl(htmlTextWriter);

            Response.Output.Write(stringWriter.ToString());
            Response.Flush();
            Response.End();
        }
    }

    private DataTable GetDataTable()
    {
        // 在这里编写获取数据表的代码
        // 返回一个包含数据的DataTable对象
    }
}