使用C#导出Microsoft Excel .xls文件的方法

<%@ Page. ..............EnableEventValidation="false"   

GridView1.设置  AllowPaging="false"



 /// <summary>   
        /// 导出为Excel   
        /// </summary>   
        /// <param name="ctl">控件ID</param>   
        /// <param name="FileName">文件名</param>   
        protected void ToExcel(System.Web.UI.Control ctl, string FileName)
        {
            HttpContext.Current.Response.Charset = "gb2312";
            HttpContext.Current.Response.ContentEncoding = System.Text.Encoding.GetEncoding("gb2312");
            HttpContext.Current.Response.ContentType = "application/ms-excel";
            HttpContext.Current.Response.AppendHeader("Content-Disposition", "attachment;filename=" + "" + FileName);
            ctl.Page.EnableViewState = false;
            System.IO.StringWriter tw = new System.IO.StringWriter();
            HtmlTextWriter hw = new HtmlTextWriter(tw);
            ctl.RenderControl(hw);
            HttpContext.Current.Response.Write(tw.ToString());
            HttpContext.Current.Response.End();
        }
         



        /// <summary>   
        /// 导出为Excel