public void ToExcel(System.Web.UI.Control ctl, string FileName)

{

HttpContext.Current.Response.Charset = "UTF-8"; // 或UTF-7 以防乱码

HttpContext.Current.Response.ContentEncoding = System.Text.Encoding.Default;

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

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

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();

ctl.Page.EnableViewState = true;

}