最新下载
热门教程
- 1
- 2
- 3
- 4
- 5
- 6
- 7
- 8
- 9
- 10
关于DataGrid 数据导入Excel乱码
时间：2022-06-30 10:29:14 编辑：袖梨 来源：一聚教程网
当导数据到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不支持中文
原来代码
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不支持中文
相关文章
- 哈利波特魔法觉醒巧克力蛙第六天在哪?巧克力蛙第六天npc线索 08-02
- XRP ETF决定可能在21天内出炉。原因如下 08-02
- 哈利波特巧克力蛙第四天在哪?巧克力蛙第四天npc线索位置 08-02
- 今日五个新地址累计提走2.85亿美元ETH 08-02
- 《天涯明月刀手游》S2赛季莲池湖话本攻略 08-02
- 5800万美元的Shiba Inu被锁定，SHIB价格接下来会怎样？ 08-02