GridView 转EXCEL 代码

   自己的代码保存以后备用，绝对可以用的。

  

    注：为了避免错误，你必须在default.aspx页面把第一行改成（红色为添加进去的）

     <%@ Page Language="C#"EnableEventValidation = "false"  AutoEventWireup="true"    CodeBehind="default.aspx.cs" Inherits="TestWeb._default" %>

        public override void VerifyRenderingInServerForm(Control control)

        {

            // Confirms that an HtmlForm control is rendered for

             //函数体内没有任何代码，切记

        }

        private void Export(Control ctl, string FileType, string FileName)
        {
            Response.Charset = "UTF-8";
            Response.ContentEncoding = System.Text.Encoding.UTF8;
            Response.AppendHeader("Content-Disposition", "attachment;filename=" + HttpUtility.UrlEncode(FileName, System.Text.Encoding.UTF8).ToString());
            Response.ContentType = FileType;
            this.EnableViewState = false;
            System.IO.StringWriter tw = new System.IO.StringWriter();
            HtmlTextWriter hw = new HtmlTextWriter(tw);

            ctl.RenderControl(hw);

           //因为实际上使用DataGride控件导出的数据实际上就是一个table.跟HTML标签是一样的。因此Excel既然可以识别HTML的Table标签那么也应该可以识别HTML声明。这样Excel就知道该用什么字符集去解析内容了

            Response.Write("<meta http-equiv='content-type' content='application/ms-excel; charset=UTF-8'/>");  //必要时要加入以下这句

            Response.Write(tw.ToString());
            Response.End();
        }

        protected void BtnExcel_Click(object sender, EventArgs e)
        {
            Export(GV1, "application/ms-excel", "123.xls");
        }
    }