导出excel遇到中文乱码

[ant200902]

一下是我的两种方式，都是一样乱码.
方法1：
Response.ClearHeaders();
Response.Clear();
Response.Expires = 0;
Response.BufferOutput = true;
Response.Charset = "GB2312";
Response.ContentEncoding = System.Text.Encoding.GetEncoding("GB2312");
Response.AppendHeader("Content-Disposition", string.Format("attachment;filename={0}.csv", System.Web.HttpUtility.UrlEncode(fileName, System.Text.Encoding.UTF8)));
Response.ContentType = "text/h323;charset=gbk";
Response.BinaryWrite(buffer);
Response.End();

方法2：
Response.Clear();
Response.ContentType = "application/ms-excel";
Response.AddHeader("Content-Disposition", "attachment;filename=" + System.Web.HttpUtility.UrlEncode(fileName + ".csv"));
Response.AddHeader("Content-Length", buffer.Length.ToString());
Response.BinaryWrite(buffer);
Response.End();
谢谢。

[abz7676]

Response.Charset = "GB2312";

改成

Response.Charset = "UTF-8";

[abz7676]

如果还出现乱码，你的方法一改成下面的再试试：

            Response.ClearHeaders();
            Response.Clear();
            Response.Expires = 0;
            Response.BufferOutput = true;            
            Response.ContentEncoding = System.Text.Encoding.Default;
            Response.AppendHeader("Content-Disposition", string.Format("attachment;filename={0}.csv", System.Web.HttpUtility.UrlEncode(fileName, System.Text.Encoding.Default)));
            Response.ContentType = "application/ms-excel";
            Response.BinaryWrite(buffer);
            Response.End();

[ant200902]

引用 2 楼 abz7676 的回复:

如果还出现乱码，你的方法一改成下面的再试试：

            Response.ClearHeaders();
            Response.Clear();
            Response.Expires = 0;
            Response.BufferOutput = true;            
            Response.ContentEncoding = System.Text.Encoding.Default;
            Response.AppendHeader("Content-Disposition", string.Format("attachment;filename={0}.csv", System.Web.HttpUtility.UrlEncode(fileName, System.Text.Encoding.Default)));
            Response.ContentType = "application/ms-excel";
            Response.BinaryWrite(buffer);
            Response.End();

谢谢，你的代码确实能导出，但是导出的网页文件，不是excel。请问导出excel怎么做？

[还想懒够]

你导出的是CSV，在Excel里面打开CSV显示中文为乱码这太正常了。用Notepad++打开看看是不是乱码就行了。

[ant200902]

引用 2 楼 abz7676 的回复:

如果还出现乱码，你的方法一改成下面的再试试：

            Response.ClearHeaders();
            Response.Clear();
            Response.Expires = 0;
            Response.BufferOutput = true;            
            Response.ContentEncoding = System.Text.Encoding.Default;
            Response.AppendHeader("Content-Disposition", string.Format("attachment;filename={0}.csv", System.Web.HttpUtility.UrlEncode(fileName, System.Text.Encoding.Default)));
            Response.ContentType = "application/ms-excel";
            Response.BinaryWrite(buffer);
            Response.End();

我怀疑是我操作系统的问题，win 7 英文版

[ant200902]

引用 5 楼 ant200902 的回复:

[quote=引用 2 楼 abz7676 的回复:] 如果还出现乱码，你的方法一改成下面的再试试：

            Response.ClearHeaders();
            Response.Clear();
            Response.Expires = 0;
            Response.BufferOutput = true;            
            Response.ContentEncoding = System.Text.Encoding.Default;
            Response.AppendHeader("Content-Disposition", string.Format("attachment;filename={0}.csv", System.Web.HttpUtility.UrlEncode(fileName, System.Text.Encoding.Default)));
            Response.ContentType = "application/ms-excel";
            Response.BinaryWrite(buffer);
            Response.End();

我怀疑是我操作系统的问题，win 7 英文版[/quote] 一把编码方式改成Encoding.UTF8，可以导出excel，不是aspx网页了。但是还是乱码。用default的编码方式，是网页不会乱码。

[ant200902]

感谢1#， 换成另外一种方式fixe了。留给后人使用。 protected void Export(DataTable dt, string fileName) { if (dt.Rows.Count <= 0) return; this.Page.Response.Clear(); Page.Response.Buffer = true; Page.Response.Charset = "utf-8"; //01-1 Page.Response.AppendHeader("Content-Disposition", "attachment;filename=" + fileName + ".xls"); //设置输出流为简体中文 Page.Response.ContentEncoding = System.Text.Encoding.GetEncoding("utf-8"); //设置输出文件类型为excel文件 Page.Response.ContentType = "application/ms-excel"; //Page.EnableViewState = false; Page.Response.Write(TableToHtml(dt)); Page.Response.End(); } private string TableToHtml(System.Data.DataTable dt) { StringBuilder sb = new StringBuilder(); sb.AppendLine("<meta http-equiv=\"Content-Type\" content=\"text/html; charset=utf-8\">"); sb.AppendLine("<style>td { mso-number-format:\\@; } </style>"); sb.AppendLine("<table cellspacing=\"0\" cellpadding=\"5\" rules=\"all\" border=\"1\">"); //写出列名 sb.AppendLine("<tr style=\"white-space: nowrap;height:20\">"); foreach (object name in TableHeaders) { sb.AppendLine("<td>" + name.ToString() + "</td>"); } sb.AppendLine("</tr>"); sb.Append("<tr>"); for (int i = 0; i < dt.Rows.Count; i++) { foreach (object obj in FieldList.Split(',')) { sb.Append("<td>" + dt.Rows[i][obj.ToString()].ToString() + "</td>"); } sb.AppendLine("</tr>"); } sb.AppendLine("</table>"); return sb.ToString(); }

[还想懒够]

还有一种方法，你在你的Response.BinaryWrite(buffer);前面加入下面一行语句

Response.BinaryWrite(new byte[] { 0xEF, 0xBB, 0xBF });

[我是初音脑瘫粉]

引用 8 楼 jjkk168 的回复:

还有一种方法，你在你的Response.BinaryWrite(buffer);前面加入下面一行语句

Response.BinaryWrite(new byte[] { 0xEF, 0xBB, 0xBF });

太强了 韩语的也搞定了