ASP.NET 将表格导到Excel实例

前端：页面单独显示数据表

后台调用下面这个方法即可：

private void GetDC()

    {
        Response.Clear();
        Response.Buffer = true;

        //Response.Charset = "gb2312";


        Response.AppendHeader("Content-Disposition", "attachment;filename=" + HttpUtility.UrlEncode(Term+"评议表" + System.DateTime.Today.Month + System.DateTime.Today.Day + ".xls", Encoding.UTF8).ToString());

        //Response.ContentEncoding = System.Text.Encoding.GetEncoding("gb2312");
        Response.Charset="gb2312";
        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.pn.RenderControl(oHtmlTextWriter);
        Response.Write(oStringWriter.ToString());

        Response.End();
    }