/**//// <summary> /// 将Web控件或页面信息导出(不带文件名参数) /// </summary> /// <param name="source">控件实例</param> /// <param name="DocumentType">导出类型:Excel或Word</param> public void ExportControl(System.Web.UI.Control source, string DocumentType) { //设置Http的头信息,编码格式 if (DocumentType == "Excel") { //Excel HttpContext.Current.Response.AppendHeader("Content-Disposition", "attachment;filename=" + HttpUtility.UrlEncode("下载文件.xls", System.Text.Encoding.UTF8)); HttpContext.Current.Response.ContentType = "application/ms-excel"; } else if (DocumentType == "Word") { //Word HttpContext.Current.Response.AppendHeader("Content-Disposition", "attachment;filename=" + HttpUtility.UrlEncode("下载文件.doc", System.Text.Encoding.UTF8)); HttpContext.Current.Response.ContentType = "application/ms-word"; } HttpContext.Current.Response.Charset = "UTF-8"; HttpContext.Current.Response.ContentEncoding = System.Text.Encoding.UTF8; //关闭控件的视图状态 source.Page.EnableViewState = false; //初始化HtmlWriter System.IO.StringWriter writer = new System.IO.StringWriter(); System.Web.UI.HtmlTextWriter htmlWriter = new System.Web.UI.HtmlTextWriter(writer); source.RenderControl(htmlWriter); //输出 HttpContext.Current.Response.Write(writer.ToString()); } /**//// <summary> /// 将Web控件或页面信息导出(带文件名参数) /// </summary> /// <param name="source">控件实例</param> /// <param name="DocumentType">导出类型:Excel或Word</param> /// <param name="filename">保存文件名</param> public void ExportControl(System.Web.UI.Control source, string DocumentType, string filename) { //设置Http的头信息,编码格式 if (DocumentType == "Excel") { //Excel HttpContext.Current.Response.AppendHeader("Content-Disposition", "attachment;filename=" + HttpUtility.UrlEncode(filename + ".xls", System.Text.Encoding.UTF8)); HttpContext.Current.Response.ContentType = "application/ms-excel"; } else if (DocumentType == "Word") { //Word HttpContext.Current.Response.AppendHeader("Content-Disposition", "attachment;filename=" + HttpUtility.UrlEncode(filename + ".doc", System.Text.Encoding.UTF8)); HttpContext.Current.Response.ContentType = "application/ms-word"; } HttpContext.Current.Response.Charset = "UTF-8"; HttpContext.Current.Response.ContentEncoding = System.Text.Encoding.UTF8; //关闭控件的视图状态 source.Page.EnableViewState = false; //初始化HtmlWriter System.IO.StringWriter writer = new System.IO.StringWriter(); System.Web.UI.HtmlTextWriter htmlWriter = new System.Web.UI.HtmlTextWriter(writer); source.RenderControl(htmlWriter); //输出 HttpContext.Current.Response.Write(writer.ToString()); }
/// <summary> /// 针对WEB控件导出word /// </summary> /// <param name="control"></param> /// <param name="ExcelFileName"></param> public static void ExportToWord(System.Web.UI.Control control, string WordFileName) { HtmlForm form = new HtmlForm(); form.Controls.Add(control); HttpContext context = HttpContext.Current; context.Response.Clear(); context.Response.Buffer = true; context.Response.Charset = "UTF8"; context.Response.AppendHeader("Content-Disposition", "attachment;filename=" + HttpUtility.UrlEncode(WordFileName, System.Text.Encoding.UTF8) + ".doc"); context.Response.ContentEncoding = System.Text.Encoding.UTF8; //设置输出流为简体中文 context.Response.ContentType = "application/ms-Word"; //设置输出文件类型为excel文件。 System.Globalization.CultureInfo myCItrad = new System.Globalization.CultureInfo("ZH-CN", true); System.IO.StringWriter oStringWriter = new System.IO.StringWriter(myCItrad); System.Web.UI.HtmlTextWriter oHtmlTextWriter = new System.Web.UI.HtmlTextWriter(oStringWriter); control.RenderControl(oHtmlTextWriter); string charset = "<meta http-equiv=\"Content-Type\" content=\"text/html; charset=utf8\">"; context.Response.Write(charset + oStringWriter.ToString()); context.Response.End(); }
public static string RenderControlToHtml(System.Web.UI.Control ControlToRender) { System.Text.StringBuilder sb = new System.Text.StringBuilder(); System.IO.StringWriter stWriter = new System.IO.StringWriter(sb); System.Web.UI.HtmlTextWriter htmlWriter = new System.Web.UI.HtmlTextWriter(stWriter); ControlToRender.RenderControl(htmlWriter); return(sb.ToString()); }
public static string RenderControl(System.Web.UI.Control control) { StringBuilder html = new StringBuilder(); System.IO.StringWriter stringWriter = new System.IO.StringWriter(html); System.Web.UI.HtmlTextWriter htmlWriter = new System.Web.UI.HtmlTextWriter(stringWriter); control.RenderControl(htmlWriter); return(html.ToString()); }
/// <summary> /// 获取 服务器控件生成的html /// </summary> /// <param name="pCtrl"></param> /// <returns></returns> public static string GetControlHtml(System.Web.UI.Control pCtrl) { string strHtml = string.Empty; using (System.IO.StringWriter sw = new System.IO.StringWriter()) { using (System.Web.UI.HtmlTextWriter htw = new System.Web.UI.HtmlTextWriter(sw)) { pCtrl.RenderControl(htw); strHtml = sw.ToString(); } } return(strHtml); }
/// <summary> /// 将控件内容,导出EXCEL /// </summary> /// <param name="ctr"></param> public void ExportToExcel(System.Web.UI.Control ctr) { string style = @"<style> .text { mso-number-format:\@; } </script> "; Response.ClearContent(); Response.Write("<meta http-equiv=Content-Type content=text/html;charset=utf-8>"); Response.AddHeader("content-disposition", "attachment; filename=filename.xls"); Response.ContentEncoding = System.Text.Encoding.GetEncoding("GB2312"); Response.ContentType = "application/excel"; System.IO.StringWriter sw = new System.IO.StringWriter(); System.Web.UI.HtmlTextWriter htw = new System.Web.UI.HtmlTextWriter(sw); ctr.RenderControl(htw); // Style is added dynamically Response.Write(style); Response.Write(sw.ToString()); Response.End(); }
private string getHtmlFromControlRender(System.Web.UI.Control control) { StringBuilder sb; System.IO.StringWriter sw; System.Web.UI.HtmlTextWriter writer; sb = new StringBuilder(); using (sw = new System.IO.StringWriter(sb)) { using (writer = new System.Web.UI.HtmlTextWriter(sw)) { control.RenderControl(writer); } } return(sb.ToString()); }
/// <summary> /// 将 DataGrid、DataList 等数据控件中的数据导出为 Execl 文档并下载 /// </summary> /// <param name="ctl">控件</param> /// <param name="FileName">指定保存的文件名</param> public static void DataControlToExcelAndDownload(System.Web.UI.Control ctl, string FileName) { if (String.IsNullOrEmpty(FileName)) { FileName = "Excel.xls"; } HttpContext.Current.Response.AppendHeader("Content-Disposition", "attachment;filename=" + FileName); HttpContext.Current.Response.Charset = System.Text.Encoding.Default.EncodingName; HttpContext.Current.Response.ContentEncoding = System.Text.Encoding.Default; HttpContext.Current.Response.ContentType = "application/ms-excel"; ctl.Page.EnableViewState = false; System.IO.StringWriter sw = new System.IO.StringWriter(); System.Web.UI.HtmlTextWriter htw = new System.Web.UI.HtmlTextWriter(sw); ctl.RenderControl(htw); HttpContext.Current.Response.Write(sw.ToString()); HttpContext.Current.Response.End(); }
/// <summary> /// 将WebControl数据列表导出至Excel /// </summary> /// <param name="objControl"></param> /// <param name="strFileName"></param> public static void Export2Excel(System.Web.UI.Control objControl, string strFileName) { strFileName = System.Web.HttpUtility.UrlEncode(strFileName, System.Text.Encoding.UTF8); System.Web.HttpContext.Current.Response.Clear(); System.Web.HttpContext.Current.Response.Buffer = true; System.Web.HttpContext.Current.Response.Charset = "GB2312"; System.Web.HttpContext.Current.Response.AppendHeader("Content-Disposition", "attachment; filename=" + strFileName + ".xls"); System.Web.HttpContext.Current.Response.ContentEncoding = System.Text.Encoding.UTF7; System.Web.HttpContext.Current.Response.ContentType = "application/ms-excel"; System.Globalization.CultureInfo myCItrad = new System.Globalization.CultureInfo("ZH-CN", true); System.IO.StringWriter oStringWriter = new System.IO.StringWriter(myCItrad); System.Web.UI.HtmlTextWriter oHtmlTextWriter = new System.Web.UI.HtmlTextWriter(oStringWriter); objControl.RenderControl(oHtmlTextWriter); objControl = null; System.Web.HttpContext.Current.Response.Write(oStringWriter.ToString()); System.Web.HttpContext.Current.Response.Buffer = false; System.Web.HttpContext.Current.Response.End(); }