源码网商城,靠谱的源码在线交易网站 我的订单 购物车 帮助

源码网商城

asp.net 导出到CSV文件乱码的问题

  • 时间:2021-10-24 08:48 编辑: 来源: 阅读:
  • 扫一扫,手机访问
摘要:asp.net 导出到CSV文件乱码的问题
http://social.microsoft.com/Forums/zh-CN/295/thread/14a833f5-95bf-48ef-b6cf-c6028f338561 string name = System.Configuration.ConfigurationSettings.AppSettings["downloadurl"].ToString(); FileStream fs = new FileStream(name, FileMode.Create, FileAccess.Write); StreamWriter sw = new StreamWriter(fs, System.Text.Encoding.GetEncoding("gb2312")); sw.WriteLine(" 自动编号,姓名,年龄"); foreach (DataRow dr in dt.Rows) { sw.WriteLine(dr["ID"] + "," + dr["vName"] + "," + dr["iAge"]); } sw.Close(); Response.AddHeader("Content-Disposition", "attachment; filename=" + Server.UrlEncode(name)); Response.ContentType = "application/ms-excel";// 指定返回的是一个不能被客户端读取的流,必须被下载 Response.WriteFile(name); // 把文件流发送到客户端 Response.End(); 重点为红色标记处! ------ string strFile = "FileName" + DateTime.Now.ToString("yyyyMMddhhmmss") + ".csv"; //这一部分替换为你从DataTable/GridView获取的内容 StringBuilder sb = new StringBuilder(); sb.AppendLine("id,name"); sb.AppendLine("1,邹俊才"); sb.AppendLine("2,才俊邹"); sb.AppendLine("3,Jon"); StringWriter sw = new StringWriter(sb); sw.Close(); Response.AddHeader("Content-Disposition", string.Format("attachment;filename={0}", strFile)); Response.Charset = "gb2312"; Response.ContentType = "application/ms-excel"; Response.ContentEncoding = System.Text.Encoding.GetEncoding("gb2312"); Response.Write(sw); Response.Flush(); Response.End();
  • 全部评论(0)
联系客服
客服电话:
400-000-3129
微信版

扫一扫进微信版
返回顶部