" /"从gridview导出到excel的问题

大家好，



我在从gridview数据导出到Excel时遇到问题。

我有正向数据在其中一个列中的数据（/）中斜线，这些列像字符/（在这种情况下更倾斜）而不是/。同一个文件正在上传到其他一些应用程序中，这个角色在其结尾处被视为一些垃圾字符。



Ex：

实际值：25515 / DT9NN2BJ_PCDG_2015

Excel显示值：25515/DT9NN2BJ_PCDG_2015



上述值的差异在于斜线。请仔细观察。



请尽快帮助。



这是我的代码。

Hi All,

I am facing a problem in Export to Excel from a gridview data.
I have the data with forward slash in the data ("/") in one of the columns which is diplaying like a character "⁄" (slant is more in this case) instead of "/". The same file is uploading in some other application and this character is taking as some junk characters at their end.

For Ex:
Actual Value:25515/DT9NN2BJ_PCDG_2015
Displayed Value in Excel:25515⁄DT9NN2BJ_PCDG_2015

The difference in above values is in "slash". please observe it carefully.

Please help ASAP.

here is my code.

DataGrid dgExport = new DataGrid();
dgExport.DataSource = dtExport;
dgExport.DataBind();

string Excelfilename = "Test_Excel_Export" + DateTime.Now;
Response.Clear();
Response.Buffer = true;
Response.ContentType = "application/vnd.ms-excel";
Response.AppendHeader("Content-Disposition:", "attachment; filename=" + Excelfilename + ".xls");
Response.Charset = "";
Response.ContentEncoding = Encoding.Unicode;
Response.BinaryWrite(Encoding.Unicode.GetPreamble());
this.EnableViewState = false;
System.IO.StringWriter oStringWriter = new System.IO.StringWriter();          System.Web.UI.HtmlTextWriter oHtmlTextWriter = new System.Web.UI.HtmlTextWriter(oStringWriter);
dgExport.RenderControl(oHtmlTextWriter);
Response.Write(oStringWriter.ToString());
Response.End

虽然我在下面添加了两行代码，但仍然是同样的问题仍然存在。

Though I have added below two lines of code, still the same problem persists.

Response.ContentEncoding = Encoding.Unicode;
Response.BinaryWrite(Encoding.Unicode.GetPreamble());

问候

Surya

Regards
Surya