二、IE下导出Excel乱码——C#踩坑记
导出Excel在谷歌没问题,在IE下就。。。不得不吐槽,我用微软的技术导出微软的东西居然乱码,在谷歌居然不乱码。。。
解决办法:先贴高手的 https://blog.csdn.net/u014353113/article/details/84784680
////// 通过流导出Execl文件 /// /// Execl流 /// 导出Execl文件名(无需加扩展名) /// public static HttpResponseMessage ExportExecl(Stream stream, string fileName) { var file = stream; fileName += DateTime.Now.ToString("yyyyMMddHHmmss"); //string csv = _service.GetData(model); HttpResponseMessage result = new HttpResponseMessage(HttpStatusCode.OK); result.Content = new StreamContent(file); //a text file is actually an octet-stream (pdf, etc) //result.Content.Headers.ContentType = new MediaTypeHeaderValue("application/octet-stream"); result.Content.Headers.ContentType = new MediaTypeHeaderValue("application/ms-excel"); //we used attachment to force download result.Content.Headers.ContentDisposition = new ContentDispositionHeaderValue("attachment"); result.Content.Headers.ContentDisposition.FileName = clFielName(fileName + ".xls"); return result; }
////// 解决IE文件名乱码方法 /// /// 文件名 /// public static string clFielName(string fileName) { System.Web.HttpContext curContext = System.Web.HttpContext.Current; string outputFileName = null; string browser = curContext.Request.UserAgent.ToUpper(); if (browser.Contains("MS") == true && browser.Contains("IE") == true) { outputFileName = System.Web.HttpUtility.UrlEncode(fileName); } else if (browser.Contains("FIREFOX") == true) { outputFileName = "\"" + fileName + "\""; } else { outputFileName = System.Web.HttpUtility.UrlEncode(fileName); } return outputFileName; }