////// 导出为Excel /// /// 控件 /// 导出格式 /// 文件名 public static void ConvertToExcel(System.Web.UI.Control control, string encoding, string filename) { //设置文件名格式,防止中文文件名乱码 string FileName = System.Web.HttpUtility.UrlEncode(Encoding.UTF8.GetBytes(filename)); System.Web.HttpContext.Current.Response.Clear(); System.Web.HttpContext.Current.Response.Buffer = true; System.Web.HttpContext.Current.Response.Charset = "" + encoding + ""; //下面这行很重要, attachment 参数表示作为附件下载,您可以改成 online在线打开 //filename=FileFlow.xls 指定输出文件的名称,注意其扩展名和指定文件类型相符,可以为:.doc .xls .txt .htm System.Web.HttpContext.Current.Response.AppendHeader("Content-Disposition", "attachment;filename=" + FileName); System.Web.HttpContext.Current.Response.ContentEncoding = System.Text.Encoding.GetEncoding("" + encoding + ""); //Response.ContentType指定文件类型 可以为application/ms-excel、application/ms-word、application/ms-txt、application/ms-html 或其他浏览器可直接支持文档 System.Web.HttpContext.Current.Response.ContentType = "application/ms-excel"; control.EnableViewState = false; // 定义一个输入流 System.IO.StringWriter oStringWriter = new System.IO.StringWriter(); System.Web.UI.HtmlTextWriter oHtmlTextWriter = new System.Web.UI.HtmlTextWriter(oStringWriter); control.RenderControl(oHtmlTextWriter); //this 表示输出本页,你也可以绑定datagrid,或其他支持obj.RenderControl()属性的控件 System.Web.HttpContext.Current.Response.Write(oStringWriter.ToString()); System.Web.HttpContext.Current.Response.End(); }
此方法作为渲染输出! ////// 此方法必重写,否则会出错 /// /// public override void VerifyRenderingInServerForm(Control control) { }