Gridview导出excel

最新推荐文章于 2021-06-25 15:22:24 发布

weixin_34104341

最新推荐文章于 2021-06-25 15:22:24 发布

阅读量95

点赞数

文章标签： ui

本文介绍了一个使用ASP.NET处理按钮点击事件以将GridView中的数据导出为Excel文件的方法。该过程包括设置HTTP响应头、编码格式及文件名，并利用StringWriter与HtmlTextWriter渲染GridView到字符串中，最后发送到客户端。

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

    protected void Button_ServerClick(object sender, EventArgs e)
    {
        Excel ExportExcel = new Excel();
        string Year = System.DateTime.Now.Year.ToString();
        string Month = System.DateTime.Now.Month.ToString();
        string Day = System.DateTime.Now.Day.ToString();
        string DateString = Year + "-" + Month + "-" + Day;
        ExportExcel.Generate("DangAn", DateString, GridView1);
    }

    public override void VerifyRenderingInServerForm(Control control)
    {
        （必须有）
            //base.VerifyRenderingInServerForm(control);
    }

    public void Generate(string Typename, string scswId, GridView TempGrid)
    {

        HttpContext.Current.Response.Clear();
        HttpContext.Current.Response.Charset = "utf-8";
        string Filename = Typename + scswId + ".xls";
        HttpContext.Current.Response.AppendHeader("Content-Disposition", "online;filename=" + Filename);
        HttpContext.Current.Response.ContentEncoding = System.Text.Encoding.GetEncoding("utf-8");
        HttpContext.Current.Response.ContentType = "application/ms-excel";
        System.IO.StringWriter oStringWriter = new System.IO.StringWriter();
        System.Web.UI.HtmlTextWriter oHtmlTextWriter = new System.Web.UI.HtmlTextWriter(oStringWriter);
        TempGrid.RenderControl(oHtmlTextWriter);
        HttpContext.Current.Response.Write(oStringWriter.ToString());
        HttpContext.Current.Response.End();
    }