gridview导出数据至Excel office2007、2010打开乱码

gridview导出数据至Excel office2007、2010打开乱码

• 博客分类： 
• 网站后台

Excel 

原来代码

C#代码  

1. gvMonograph.DataBind();  
2.         Response.Charset = "GB2312";  
3.         Response.ContentEncoding = System.Text.Encoding.UTF7;  
4.         Response.AppendHeader("Content-Disposition", "attachment;filename=" + HttpUtility.UrlEncode(FileName, System.Text.Encoding.UTF8).ToString());  
5.         Response.ContentType = FileType;  
6.         this.EnableViewState = false;  
7.         StringWriter tw = new StringWriter();  
8.         HtmlTextWriter hw = new HtmlTextWriter(tw);  
9.         gvMonograph.RenderControl(hw);  
10.         Response.Write(tw.ToString());  
11.         Response.End();  

 需要更改一个地方也就是Response.ContentEncoding = System.Text.Encoding.UTF7;
为Response.ContentEncoding = System.Text.Encoding.UTF8; 后即可在2007 2010下正常打开

改后代码：

C#代码  

1. gvMonograph.DataBind();  
2.         Response.Charset = "GB2312";  
3.         Response.ContentEncoding = System.Text.Encoding.UTF8;  
4.         Response.AppendHeader("Content-Disposition", "attachment;filename=" + HttpUtility.UrlEncode(FileName, System.Text.Encoding.UTF8).ToString());  
5.         Response.ContentType = FileType;  
6.         this.EnableViewState = false;  
7.         StringWriter tw = new StringWriter();  
8.         HtmlTextWriter hw = new HtmlTextWriter(tw);  
9.         gvMonograph.RenderControl(hw);  
10.         Response.Write(tw.ToString());  
11.         Response.End();  

转自：http://wangwang3ok.iteye.com/blog/839594