将GridView的内容输出为Excel并提供下载

Question

请给出具体的。NET代码，谢谢。

Answer 1

一个富农还提这么简单的问题...
protected void Button1_Click(object sender, EventArgs e)
    {
       
       
        ExportDataGrid("online/ms-excel", "111.xls");
    }
    private void ExportDataGrid(string FileType, string FileName)
    {
        Response.Clear();
        Response.Buffer = true;
        Response.Charset = "utf-7";
        Response.AppendHeader("Content-Disposition", "attachment;filename=FileFlow.xls");
        Response.ContentEncoding = System.Text.Encoding.GetEncoding("utf-7");
        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);
        this.GridView1.RenderControl(oHtmlTextWriter);
        Response.Write(oStringWriter.ToString());
        Response.End();
    }
给分吧