读书人

asp.net2.0 GridView中数据导出有关问

发布时间: 2012-09-21 15:47:26 作者: rapoo

asp.net2.0 GridView中数据导出问题!
Response.Clear()
Response.Buffer = True
Response.Charset = "GB2312"
Response.AppendHeader("Content-Disposition", "attachment;filename=Container information.xls")
Response.ContentEncoding = System.Text.Encoding.UTF8
Response.ContentType = "application/ms-excel"
Dim oStringWriter As System.IO.StringWriter = New System.IO.StringWriter
Dim oHtmlTextWriter As System.Web.UI.HtmlTextWriter = New System.Web.UI.HtmlTextWriter(oStringWriter)
Me.GridView1.RenderControl(oHtmlTextWriter)
Response.Output.Write(oStringWriter.ToString)
Response.Flush()
Response.End()

我在ASP.NET 2.0使用以上方法将GridView中的数据导出到EXCEL文件中,但导出的文件中,有时候个别的excel文件中的中文字符是乱码。用了UTF7 整个excel文件都是乱码!

请各位大哥不吝赐教!!

[解决办法]
Gridview到处excel的实例:地址
[解决办法]
Response.ContentEncoding = System.Text.Encoding.UTF8

换成

Response.ContentEncoding = System.Text.Encoding.gb2312,

如果不行只有到config里面设置了

读书人网 >asp.net

热点推荐