/// <summary>

        /// 根據gridview導出excel

        /// </summary>

        /// <param name="ctl"></param>

        public void DGToExcel(System.Web.UI.Control ctl)

        {

            HttpContext.Current.Response.AppendHeader("Content-Disposition", "attachment;filename=Excel.xls");

            HttpContext.Current.Response.Charset = "UTF-8";

            HttpContext.Current.Response.ContentEncoding = System.Text.Encoding.GetEncoding("GB2312");

            HttpContext.Current.Response.ContentType = "application/ms-excel";

            ctl.Page.EnableViewState = false;

            System.IO.StringWriter tw = new System.IO.StringWriter();

            System.Web.UI.HtmlTextWriter hw = new System.Web.UI.HtmlTextWriter(tw);

            ctl.RenderControl(hw);

            HttpContext.Current.Response.Write(tw.ToString());

            HttpContext.Current.Response.End();

        }

        public override void VerifyRenderingInServerForm(Control control)

        {

        }