首页 > 代码库 > Asp.NET中把DataTable导出为Excel ,中文有乱码现象解决办法

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();

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