文档详情

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

发布:2017-06-07约小于1千字共2页下载文档
文本预览下载声明
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();
显示全部
相似文档