今天在处理gridview导出数据到excel的时候遇到了中文乱码的问题
代码如下:
protected void Button2_Click(object sender, EventArgs e)
{
Response.Clear();
Response.AppendHeader("Content-Disposition", "attachment;filename=\"" + System.Web.HttpUtility.UrlEncode("table", System.Text.Encoding.UTF8) + ".xls\"");
Response.ContentEncoding = System.Text.Encoding.GetEncoding("utf-8");
Response.ContentType = "application/ms-excel";
StringWriter stringWrite = new StringWriter();
HtmlTextWriter htmlWrite = new HtmlTextWriter(stringWrite);
GridView1.RenderControl(htmlWrite);
Response.Write(stringWrite.ToString());
Response.End();
}
导入到excel后中文出现了乱码
我用的是excel2003请问高手们 怎么解决这个问题啊?
代码如下:
protected void Button2_Click(object sender, EventArgs e)
{
Response.Clear();
Response.AppendHeader("Content-Disposition", "attachment;filename=\"" + System.Web.HttpUtility.UrlEncode("table", System.Text.Encoding.UTF8) + ".xls\"");
Response.ContentEncoding = System.Text.Encoding.GetEncoding("utf-8");
Response.ContentType = "application/ms-excel";
StringWriter stringWrite = new StringWriter();
HtmlTextWriter htmlWrite = new HtmlTextWriter(stringWrite);
GridView1.RenderControl(htmlWrite);
Response.Write(stringWrite.ToString());
Response.End();
}
导入到excel后中文出现了乱码
我用的是excel2003请问高手们 怎么解决这个问题啊?
解决方案 »
- Linq 去除重复字段,速度求解!
- 产品图片太多,怎么优化下载速度
- url重写网站,删除数据后重新绑定gridview地址又变回真实的了,怎么办
- 怎样把asp.net2.0生成dll文件
- 用SqlDataSource筛选后GRIDVIEW的自动分页功能怎么让他使用筛选后的结果分页
- (散分了!高手请!)如何实现qq在线即时交谈,以及 adrotator 轮显问题
- 这个函数该为datareader怎么写?
- 播放 .flv 文件
- 急切求助: IsPostBack 与 Request之间的矛盾
- 给推荐本.net书吧
- 控制用户访问权限的实现原理
- 请教:访问规则 的信息是存放在哪啊?怎么没在aspnet数据库里?也没在config里
System.Globalization.CultureInfo ctinfo = new System.Globalization.CultureInfo("zh-CN", true);
Response.Charset = "gb2312";
Response.ContentEncoding = System.Text.Encoding.UTF8
改为:Response.ContentEncoding = System.Text.Encoding.UTF7就可以了。
多谢回帖