gridview 导出excel

最新推荐文章于 2025-11-25 09:31:03 发布

原创最新推荐文章于 2025-11-25 09:31:03 发布 · 274 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#button #excel #object

本文介绍了一种使用ASP.NET中的GridView控件将数据导出为Excel文件的方法。通过设置HTTP响应头并利用StringWriter与HtmlTextWriter来捕获GridView的HTML输出，最终生成Excel文件供用户下载。

public override void VerifyRenderingInServerForm(Control control)
    {
        // Confirms that an HtmlForm control is rendered for
    }
    protected void Button1_Click(object sender, EventArgs e)
    {
        Response.Clear();
        Response.Buffer = true;
        Response.Charset = "GB2312";
        Response.AppendHeader("Content-Disposition", "attachment;filename=FileName.xls");
        Response.ContentEncoding = System.Text.Encoding.UTF7;
        Response.ContentType = "application/ms-excel";
        System.IO.StringWriter oStringWriter = new System.IO.StringWriter();
        System.Web.UI.HtmlTextWriter oHtmlTextWriter = new System.Web.UI.HtmlTextWriter(oStringWriter);
        DataTable dtTmp = (DataTable)this.GridView1.DataSource;
        this.GridView1.AllowPaging = false;
        GridView1.DataSource = dtTmp;
        GridView1.DataBind();
        GridView1.RenderControl(oHtmlTextWriter);
        Response.Output.Write(oStringWriter.ToString());
        this.GridView1.AllowPaging = true;
        GridView1.DataSource = dtTmp;
        GridView1.DataBind();
        Response.Flush();
        Response.End();
    }