GridView导出数据到Excel

最新推荐文章于 2025-08-08 15:15:41 发布

wostyh

最新推荐文章于 2025-08-08 15:15:41 发布

阅读量313

点赞数

CC 4.0 BY-SA版权

文章标签： excel string

本文链接：https://blog.youkuaiyun.com/wostyh/article/details/3550785

本文介绍了一种使用ASP.NET将GridView数据导出到Excel的方法。通过设置Response属性及使用StringWriter与HtmlTextWriter来实现网格数据的导出，同时注意编码格式及文件名的处理。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

private void ExportToExcel()
{

        Response.Clear();
        Response.Charset = "GB2312";
        Response.ContentEncoding = System.Text.Encoding.GetEncoding("GB2312");

        string FileName = "文件名.xls";
        Response.AppendHeader("Content-Disposition", "attachment;filename=" + HttpUtility.UrlEncode(FileName, System.Text.Encoding.UTF8).ToString());
        Response.ContentType = "application/ms-excel";
        this.EnableViewState = false;
        StringWriter tw = new StringWriter();
        HtmlTextWriter hw = new HtmlTextWriter(tw);
        GridView1.AllowPaging = false;
        GVDataBind();
        GridView1.Columns[6].Visible = false;
        GridView1.Columns[7].Visible = false;
        GridView1.RenderControl(hw);
        Response.Write(tw.ToString());
        Response.End();
        GridView1.AllowPaging = true;
        GVDataBind();
    }