asp.net 导出GridView、其它控件到Excel(防止中文乱码)
来源:互联网 发布:java返回页面 编辑:程序博客网 时间:2024/05/16 18:04
/// <summary>
/// 导出到EXCEL
/// </summary>
/// <param name="ctl"></param>
/// <param name="FileName"></param>
public void ToExcel(System.Web.UI.Control ctl, string FileName)
{
HttpContext.Current.Response.Charset = "GB2312"; // 或UTF-7 以防乱码
HttpContext.Current.Response.ContentEncoding = System.Text.Encoding.GetEncoding("GB2312");
//HttpContext.Current.Response.ContentType = "application/octet-stream";
HttpContext.Current.Response.ContentType = "application/vnd.ms-excel";
Response.Write("<meta http-equiv=Content-Type content=\"text/html; charset=GB2312\">");//出现中文乱码加这句
HttpContext.Current.Response.AppendHeader("Content-Disposition", "attachment;filename=" + System.Web.HttpUtility.UrlEncode(System.Text.Encoding.UTF8.GetBytes(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 = false;
}
/// 导出到EXCEL
/// </summary>
/// <param name="ctl"></param>
/// <param name="FileName"></param>
public void ToExcel(System.Web.UI.Control ctl, string FileName)
{
HttpContext.Current.Response.Charset = "GB2312"; // 或UTF-7 以防乱码
HttpContext.Current.Response.ContentEncoding = System.Text.Encoding.GetEncoding("GB2312");
//HttpContext.Current.Response.ContentType = "application/octet-stream";
HttpContext.Current.Response.ContentType = "application/vnd.ms-excel";
Response.Write("<meta http-equiv=Content-Type content=\"text/html; charset=GB2312\">");//出现中文乱码加这句
HttpContext.Current.Response.AppendHeader("Content-Disposition", "attachment;filename=" + System.Web.HttpUtility.UrlEncode(System.Text.Encoding.UTF8.GetBytes(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 = false;
}
0 0
- asp.net 导出GridView、其它控件到Excel(防止中文乱码)
- Asp.net Gridview 导出到Excel【解决编码乱码问题】
- ASP.NET 导出Panel、GridView控件到Excel或Word
- 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 导出excel 中文乱码解决方法
- ASP.NET 2.0,C#----利用GridView控件导出其他文件(导出Excel,导出Word文件)
- ASP.NET导出到EXCEL(控件式样)
- asp.net 中GridView控件直接导出Excel文件
- Asp.net GridView 导出Excel
- .net从gridview控件导出数据到excel续
- ASP.NET 2.0中将 GridView 导出到 Excel 文件中
- ASP.NET 2.0中将 GridView 导出到 Excel 文件中
- ASP.NET 2.0中将 GridView 导出到 Excel 文件中
- AngularJS http://www.w3cschool.cc/angularjs/angularjs-tutorial.html
- 编辑文章 - 博客频道 - CSDN.NET
- 第十三周阅读项目(3):纯虚函数
- Struts2 结合 Ajax 实现异步交互数据
- 使用CXF开发RESTFul服务
- asp.net 导出GridView、其它控件到Excel(防止中文乱码)
- mysql 中文乱码问题
- SQLiteDataBase数据库的使用
- 第13周 【项目1-动物这样叫】(3)
- 新SAT数学样题及答案Question 16
- 设计模式
- 微软100题(32)交换两个数组元素,使得两个数组和差值最小
- C#学习 - 关于值类型和引用类型
- Struts2注解