关于DataGrid 数据导入Excel乱码 - 中国WEB开发者网络 (http://www.webasp.net) -- 技术教程 (http://www.webasp.net/article/) --- 关于DataGrid 数据导入Excel乱码 (http://www.webasp.net/article/16/15227.htm) |
| -- 作者:未知 -- 发布日期: 2004-12-02 |
| 当导数据到Excel 中时有时会出现乱码
原来代码 private static void WriteToExcelFromDataGrid(DataGrid dg, string fileName) { //StringWriter tw = new StringWriter(new CultureInfo( "zh-CHS", false)); StringWriter tw = new StringWriter(); HtmlTextWriter hw = new HtmlTextWriter(tw); dg.RenderControl(hw); System.Web.HttpResponse response = System.Web.HttpContext.Current.Response; response.Clear(); response.ContentEncoding=System.Text.Encoding.GetEncoding("utf-8"); response.ContentType ="application/vnd.ms-excel"; response.AddHeader("Content-Disposition", "attachment; filename=" + fileName); response.Charset = "gb2312"; response.Write(tw.ToString()); response.End(); } 正确 response.ContentEncoding=System.Text.Encoding.GetEncoding("utf-7"); 原因 utf-8不支持中文 |
| webasp.net |