在把DataGrid中的数据导入excel表格时,excel表格会出现乱码,请高人指点,谢谢

解决方案 »

  1.   

    你是BS还是CS啊? HttpContext.Current.Response.AppendHeader("Content-Disposition", "attachment;filename=Excel.xls")
            Response.ContentType = "application/vnd.ms-excel"
            HttpContext.Current.Response.Charset = ""
            HttpContext.Current.Response.ContentEncoding = System.Text.Encoding.Default
            DataGrid1.Page.EnableViewState = False
            Dim tw As StringWriter = New StringWriter()
            Dim hw As New HtmlTextWriter(tw)
            DataGrid1.Visible = True
            DataGrid1.RenderControl(hw)
            HttpContext.Current.Response.Write(tw.ToString())
            HttpContext.Current.Response.End()
      

  2.   

    HttpContext.Current.Response.Charset = "gb2312"