Asp.NET中把DataTable导出为Excel ，中文有乱码现象解决办法

　　　　　 //DataTable为要导出的数据表

　　　　　  DataGrid dg = new DataGrid();
                dg.DataSource = DataTable;
                dg.DataBind();

                //如果文件名称有中文，指定编码
                string fileName = HttpUtility.UrlEncode("JobHistoryList", Encoding.UTF8).ToString();

                //设置编码格式
                HttpContext.Current.Response.Clear();
                HttpContext.Current.Response.Charset = "UTF-8";// "UTF-8"或者"GB2312"
                HttpContext.Current.Response.ContentType = "application/vnd.ms-excel";//text/csv
                HttpContext.Current.Response.ContentEncoding = System.Text.Encoding.UTF8;
                HttpContext.Current.Response.AppendHeader("Content-Disposition", "attachment;filename=" + fileName + ".xls");
                //导出excel
                System.IO.StringWriter oSW = new System.IO.StringWriter();
                HtmlTextWriter oHW = new HtmlTextWriter(oSW);
                dg.RenderControl(oHW);

              

　　　　　　//输出时加上"<meta http-equiv=\"content-type\" content=\"application/ms-excel; charset=UTF-8\"/>"解决编码问题

　　　　　　//返回浏览器，
                HttpContext.Current.Response.Write("<meta http-equiv=\"content-type\" content=\"application/ms-excel; charset=UTF-8\"/>" + oSW.ToString());
                HttpContext.Current.Response.End();

转载于:https://www.cnblogs.com/johnblogs/p/6112892.html