C#导出Excel文件名中文乱码问题.doc
文本预览下载声明
C#导出Excel文件名中文乱码问题
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();
显示全部