求助：datagrid导出的excel文件出现乱码，vb.net，webform下.
问题是：datagrid导出的excel在打开时候出现乱码。如何处理？？谢谢。
原代码如下：
Response.ContentType = "application/vnd.ms-excel "
Response.Charset = " "
Me.EnableViewState = False
Dim sw As System.IO.StringWriter = New System.IO.StringWriter
Dim hw As System.Web.UI.HtmlTextWriter = New HtmlTextWriter(sw)
Dim ncur As Int32 = dg_detail.CurrentPageIndex
Dim nsize As Int32 = dg_detail.PageSize
dg_detail.AllowPaging = False
Call Me.binddata()
' int nCur = dgShow.CurrentPageIndex;
'int nSize = dgShow.PageSize;
' dgShow.AllowPaging = false;
'BindData();
Me.dg_detail.Columns(4).Visible = False
Me.dg_detail.Columns(5).Visible = False
Me.dg_detail.RenderControl(hw)
Me.dg_detail.Columns(4).Visible = True
Me.dg_detail.Columns(5).Visible = True
dg_detail.AllowPaging = True
dg_detail.CurrentPageIndex = ncur
dg_detail.PageSize = nsize
Call Me.binddata()
'dgShow.AllowPaging = true;
'dgShow.CurrentPageIndex = nCur;
'dgShow.PageSize = nSize;
'BindData();
'System.IO.StringWriter sw = new System.IO.StringWriter();
'System.Web.UI.HtmlTextWriter hw = new System.Web.UI.HtmlTextWriter(sw);
'dgShow.RenderControl(hw);
Response.Write(sw.ToString())
Response.End()
不胜感激～！
[解决办法]
再有可能就是编码问题罢 utf-8 不行就试试 utf-7 很久很久以前同事遇到过这个问题 然后我就gg了到了utf-7 解决了 另外LZ的office是哪个版本
[解决办法]
Response.ContentEncoding = System.Text.Encoding.UTF7;//解决乱码问题
Response.ContentType = "application/ms-excel ";
