读书人

html table中的数据导出excel表的时候

发布时间: 2012-02-03 22:02:47 作者: rapoo

html table中的数据导出excel表的时候为乱码,请问如何解决?
--代码如下


Response.AddHeader( "Content-Disposition ", "attachment; filename=ExcelFile ")
Response.Charset = "UTF-8 "
Response.ContentType = "application/vnd.ms-excel "
Response.Charset = " "
Me.EnableViewState = False
Dim tw As New System.IO.StringWriter
Dim hw As New System.Web.UI.HtmlTextWriter(tw)
tblsbu.RenderControl(hw)
Response.Write(tw.ToString())
Response.End()

[解决办法]
Response.ContentType = "application/vnd.ms-excel "
Response.AddHeader( "Content-Disposition ", "attachment; filename=ExcelFile ",Encoding.UTF8)

Me.EnableViewState = False
Dim tw As New System.IO.StringWriter
Dim hw As New System.Web.UI.HtmlTextWriter(tw)
tblsbu.RenderControl(hw)
Response.Write(tw.ToString())
Response.End()

读书人网 >asp.net

热点推荐