带母版页的GRIDVIEW导出到EXCEL方法

最新推荐文章于 2025-12-10 08:40:21 发布

原创最新推荐文章于 2025-12-10 08:40:21 发布 · 684 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#excel #path

本文介绍如何使用ASP.NET中的GridView控件将数据导出到Excel文件中。具体步骤包括禁用分页、设置响应头、指定内容类型、编码设置、创建StringWriter与HtmlTextWriter对象并利用GridView的RenderControl方法来输出数据。

        GridView1.AllowPaging = false;
        //string path = Server.MapPath("Draw.xls");
        Response.ClearContent();
        Response.AddHeader("content-disposition", "attachment; filename=Draw.xls");
        Response.ContentType = "application/excel";
        Response.ContentEncoding = System.Text.Encoding.GetEncoding("GB2312");

        StringWriter sw = new StringWriter();
        HtmlTextWriter htw = new HtmlTextWriter(sw);
        GridView1.RenderControl(htw);
        Response.Write(sw.ToString());
        Response.End();

GridView1.AllowPaging = true;

增加一空方法

public override void VerifyRenderingInServerForm(Control control)
{
}