.NET导出EXCEL出现乱码问题

来源：互联网发布：板胡校音器软件编辑：程序博客网时间：2024/05/16 14:44

if (rptOut.Items.Count == 0) { MessageBox.Show(ltMessage, "导出项为空或者数据量大于" + AppConfig.Sys_Page_MaxOutExeclData + ",请进一步增加查询条件", 0); return; } StringWriter sw = new StringWriter(); HtmlTextWriter hw = new HtmlTextWriter(sw); string fileName = "订单列表(" + DateTime.Now.ToString("yyyy-MM-dd-HH-mm-ss"); string outputFileName = string.Empty; string browser = this.Context.Request.UserAgent.ToUpper(); if (browser.Contains("MS") == true && browser.Contains("IE") == true) { outputFileName = HttpUtility.UrlEncode(fileName); } else if (browser.Contains("FIREFOX") == true) { outputFileName = "/"" + fileName + "/""; } else if (browser.Contains("AIX")) { //outputFileName = Convert.ToString(fileName, "utf-8"); //fileName } else { outputFileName = HttpUtility.UrlEncode(fileName); } this.rptOut.RenderControl(hw); Response.Clear(); Response.ContentType = "application/vnd.ms-excel"; Response.Charset = ""; rptOut.Page.EnableViewState = true; Response.AppendHeader("Content-Disposition", "attachment;filename=/"" + outputFileName + ").xls/""); Response.Write("<html><head><meta http-equiv=Content-Type content=/"text/html; charset=UTF8/"><title>票务宝</title></head><body>"); Response.Write(sw.ToString()); Response.Write("</body></html>"); Response.End();