将带有阿拉伯文数据的数据表导出到Excel

Question

我有一个由阿拉伯语数据组成的数据表。当我将其导出到 excel 时，我无法正确获取阿拉伯语数据。

目前我的代码如下，

  public void ExportExcel(DataTable table, string filename)
    {
        if (table != null && filename != "")
        {

            HttpContext.Current.Response.Clear();
            HttpContext.Current.Response.Buffer = true;

            HttpContext.Current.Response.AddHeader("content-disposition", "attachment;attachment;filename=" + filename + ".xls");
            HttpContext.Current.Response.Charset = "";
            HttpContext.Current.Response.ContentType = "application/vnd.ms-excel";               
            System.IO.StringWriter stringWrite = new System.IO.StringWriter();

            System.Web.UI.HtmlTextWriter htmlWrite =
            new HtmlTextWriter(stringWrite);

            GridView GrdExcel = new GridView();
            GrdExcel.AllowPaging = false;
            GrdExcel.DataSource = table;
            GrdExcel.DataBind();
            for (int i = 0; i < GrdExcel.Rows.Count; i++)
            {
                GridViewRow row = GrdExcel.Rows[i];                   
                row.Attributes.Add("class", "text");
            }
            GrdExcel.RenderControl(htmlWrite);
            string style = @"<style> .textmode { mso-number-format:\@; } </style>";
            HttpContext.Current.Response.Write(style);
            HttpContext.Current.Response.Output.Write(stringWrite.ToString());
            HttpContext.Current.Response.Flush();
            HttpContext.Current.Response.End();


        }

    }

编辑1:

以下是对我有效的最终代码

             ////If you want the option to open the Excel file without saving than

             ////comment out the line below

            HttpContext.Current.Response.Cache.SetCacheability(HttpCacheability.NoCache);

            HttpContext.Current.Response.Clear();
            HttpContext.Current.Response.Buffer = true;
            HttpContext.Current.Response.Charset = "UTF-8";
            HttpContext.Current.Response.ContentEncoding = System.Text.Encoding.UTF8;
            HttpContext.Current.Response.AddHeader("content-disposition", "attachment;attachment;filename=" + filename + ".xls");

            HttpContext.Current.Response.ContentType = "application/vnd.ms-excel";


            System.IO.StringWriter stringWrite = new System.IO.StringWriter();

            System.Web.UI.HtmlTextWriter htmlWrite =
            new HtmlTextWriter(stringWrite);
            DataGrid grdExcel = new DataGrid();
            grdExcel.AllowPaging = false;
            grdExcel.DataSource = table;
            grdExcel.DataBind();
            foreach (DataGridItem i in grdExcel.Items)
            {

                foreach (TableCell tc in i.Cells)
                    tc.Attributes.Add("class", "text");

            }
            grdExcel.RenderControl(htmlWrite);
            string style = @"<style> .text { mso-number-format:\@; } </style> ";
            HttpContext.Current.Response.Write(style);
            HttpContext.Current.Response.Write(stringWrite.ToString());
            HttpContext.Current.Response.Flush();
            HttpContext.Current.Response.End();   

这是通过引用网络上的几篇文章编写的。希望能有所帮助

Answer 1

中的每个字符串换行Encoding.UTF8. GetString（用于ex：Encoding.UTF8. GetString（str））

在web.config：

<system.web>
    <globalization requestEncoding="utf-8" responseEncoding="utf-8" culture="he-IL"/>
</system.web>

he-IL 就我而言，分别写下您的语言文化

Answer 2

将此代码添加到您的代码中：

HttpContext.Current.Response.Charset = "UTF-8";
HttpContext.Current.Response.ContentEncoding = System.Text.Encoding.UTF8;