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

个性小资

于 2008-07-25 16:10:00 发布

阅读量676

点赞数

CC 4.0 BY-SA版权

文章标签： excel path

本文链接：https://blog.youkuaiyun.com/qcdn/article/details/2710583

本文介绍如何使用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)
{
}