正文
ASP.NET 导出excel文件出现乱码的解决办法
提示：扫一扫查出行【扫一扫了解最新限行尾号】
复制提示
string html =TABLE ;//<table>标签，可以是多张表
string modified = Regex.Replace(html, "<table >", "<table cellspacing=\"0\" rules=\"all\" border=\"1\" style=\"border-collapse:collapse;\">");//用正则表达式进行规范
Response.Clear();
Response.Buffer = true;
Response.Charset = "GB2312";
Response.AddHeader("Content-Disposition", "attachment;filename=" + Server.UrlEncode("文件名称.xls"));
Response.ContentEncoding = System.Text.Encoding.GetEncoding("GB2312");//设置输出流为简体中文
Response.ContentType = "application/vnd.ms-excel";
Response.Cache.SetCacheability(HttpCacheability.NoCache); // not necessarily required
Response.Output.Write(modified);
Response.Flush();
Response.End();
string modified = Regex.Replace(html, "<table >", "<table cellspacing=\"0\" rules=\"all\" border=\"1\" style=\"border-collapse:collapse;\">");//用正则表达式进行规范
Response.Clear();
Response.Buffer = true;
Response.Charset = "GB2312";
Response.AddHeader("Content-Disposition", "attachment;filename=" + Server.UrlEncode("文件名称.xls"));
Response.ContentEncoding = System.Text.Encoding.GetEncoding("GB2312");//设置输出流为简体中文
Response.ContentType = "application/vnd.ms-excel";
Response.Cache.SetCacheability(HttpCacheability.NoCache); // not necessarily required
Response.Output.Write(modified);
Response.Flush();
Response.End();
