ASP.NET GridView导出
来源:互联网 发布:淘宝店铺出租风险 编辑:程序博客网 时间:2024/05/17 23:44
/// <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")
{
//防止出现乱码,加上这行可以防止在只有一行数据时出现乱码Gridview数据导出到Excel/Word <wbr>防止出现乱码
HttpContext.Current.Response.Write("<meta http-equiv=Content-Type content=text/html;charset=UTF-8>");
//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")
{
//防止出现乱码,加上这行可以防止在只有一行数据时出现乱码Gridview数据导出到Excel/Word <wbr>防止出现乱码
HttpContext.Current.Response.Write("<meta http-equiv=Content-Type content=text/html;charset=UTF-8>");
//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());
HttpContext.Current.Response.End();
}
public override void VerifyRenderingInServerForm(Control control)
{
}
0 0
- ASP.NET GridView导出
- Asp.net GridView 导出Excel
- Asp.net GridView 导出到Excel
- ASP.NET利用GridView导出EXCEL
- asp.net GridView导出excel表
- asp.net gridview导出Excel、World文档
- asp.net gridview 数据导出到excel
- ASP.NET关于GridView导出Excel
- ASP.NET GridView导出数据到Excel
- asp.net指定GridView 导出Excel
- asp.net gridview导出到Excel中。
- asp.net gridview 导出到excel
- asp.net GridView数据导出到Excel
- C# ASP.NET GridView导出EXCEL。
- 【asp.net】将GridView数据导出Excel
- ASP.NET 2.0中将 GridView 导出到 Excel 文件中
- ASP.NET 2.0中将 GridView 导出到 Excel 文件中
- ASP.NET 2.0中将 GridView 导出到 Excel 文件中
- 《机动车驾驶证申领和使用规定》(公安部令第123号)
- OpenGL_ES- 状态查询
- JAVA的数据类型
- php五大运行模式CGI,FAST-CGI,CLI,ISAPI,APACHE模式浅谈
- oracle 刷新组保证主从表的数据同步拷贝
- ASP.NET GridView导出
- 类的自动传唤和强制类型转换
- EMVTag系列1《数据分组》
- Java直接调用Python
- 关于gap的Buchberger算法
- C++指针理解
- 备忘
- AndroidPN 推送服务环境建立
- Objc Runtime 学习笔记