asp.net导出EXCEL的功能代码

　　//由gridviw导出为Excel

　　public static void ToExcel(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.Default;

　　HttpContext.Current.Response.ContentType = "application/ms-excel";//image/JPEG;text/HTML;image/GIF;vnd.ms-excel/msword

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

　　}