当前位置: 代码迷 >> ASP.NET >> html table中的数据导出excel表的时候为乱码,请教怎么解决
  详细解决方案

html table中的数据导出excel表的时候为乱码,请教怎么解决

热度:4224   发布时间:2013-02-26 00:00:00.0
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()
  相关解决方案