asp.net导出excel乱码问题

最新推荐文章于 2024-09-16 16:05:38 发布

jimlong

最新推荐文章于 2024-09-16 16:05:38 发布

阅读量1.8k

点赞数

文章标签： excel asp.net html web

本文链接：https://blog.csdn.net/jimlong/article/details/3943917

版权

   this.BonusList.DataSource = ds;
   this.BonusList.DataBind();

//   Response.AddHeader("Content-Type", "application/vnd.ms-excel");
//   Response.AddHeader("Content-Disposition", "attachment;filename=[Month-Detail]-"+FileName.ToString()+"");
//   Response.Charset = "";
//   ResponseEncoding="utf-8";//以此编码模式导出才不会出现乱码

   Response.Clear();
   Response.Buffer = true;
   Response.Charset = "GB2312";
   Response.AddHeader("Content-Disposition", "attachment;filename=[Month-Detail]-"+FileName.ToString()+"");
   // 如果设置为 GetEncoding("GB2312");导出的文件将会出现乱码！！！
   Response.ContentEncoding = System.Text.Encoding.UTF7;
   Response.ContentType = "application/ms-excel";//设置输出文件类型为excel文件。

   //关闭 ViewState
   EnableViewState = false;
   System.IO.StringWriter tw = new System.IO.StringWriter();//将信息写入字符串
   System.Web.UI.HtmlTextWriter hw = new System.Web.UI.HtmlTextWriter(tw);//在WEB窗体页上写出一系列连续的HTML特定字符和文本。