C#导出Excel文件名中文乱码问题

C#导出Excel文件名中文乱码问题

string nm="["+Label1.Text+"]"+ DateTime.Now.ToString("yyyy-mm-dd")+".xls"; DataTable dt = sqlHelp.GetObject(sql).Tables[0];

StringBuilder sb = new StringBuilder();

sb.Append("成绩排名\t考试成绩\t学员名称\t考试时间");

StringWriter sw = new StringWriter();

sw.WriteLine(sb.ToString());

for (int i = 0; i < dt.Rows.Count; i++)

{

int q = i + 1;

sb = new StringBuilder();

sb.Append(q.ToString());

sb.Append("\t" + dt.Rows[i][0].ToString());

sb.Append("\t" + dt.Rows[i][1].ToString() + "\t" + dt.Rows[i][2].ToString());

sw.WriteLine(sb.ToString());

}

sw.Close();

Response.Clear();

Response.Buffer = true;

Response.Charset = "GB2312";

Response.AddHeader("Content-Disposition", "attachment; filename=" + HttpUtility.UrlEncode(nm, Encoding.UTF8).ToString());

Response.ContentType = "application/ms-excel";// 指定返回的是一个不能被客户端读取的流，必须被下载

Response.ContentEncoding =

System.Text.Encoding.Default;//.GetEncoding("GB2312");

Response.Write(sw);// 把流发送到客户端

Response.End();