GridView导成Excel

最新推荐文章于 2021-08-27 21:02:31 发布

原创最新推荐文章于 2021-08-27 21:02:31 发布 · 857 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#string #excel

代码杂记专栏收录该内容

20 篇文章

订阅专栏

本文介绍了一个使用ASP.NET将GridView数据导出为Excel文件的方法。通过设置HTTP响应头和编码，确保了导出文件的正确显示。该示例还展示了如何利用StringWriter和HtmlTextWriter来渲染表格。

using System.Data;
using System.Web;
using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;
using System.Reflection;

...............

public void Generate(string Typename, string scswId, GridView TempGrid)
    {
        //HttpContext.Current.Response.Charset = "utf-8";
        //HttpContext.Current.Response.ContentEncoding = System.Text.Encoding.GetEncoding("gb2312");
        HttpContext.Current.Response.Clear();
        HttpContext.Current.Response.Buffer = true;
        HttpContext.Current.Response.Charset = "GB2312";
        string Filename = Typename + scswId + ".xls";
        HttpContext.Current.Response.AppendHeader("Content-Disposition", "online;filename=" + Filename);
        HttpContext.Current.Response.ContentEncoding = System.Text.Encoding.Default;
        HttpContext.Current.Response.ContentType = "application/ms-excel";
        //this.EnableViewState = false;
        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();
    }