gridview导出excel乱码问题。全部数据导出的时候不乱码，但是隐藏部分列不想导出的时候乱码
用到的导出代码：
- C# code
public void GridviewToExcel(Control ctl, string FileName) { HttpContext.Current.Response.Charset = "GB2312"; HttpContext.Current.Response.ContentEncoding = System.Text.Encoding.UTF8; HttpContext.Current.Response.ContentType = "application/ms-excel"; HttpContext.Current.Response.AppendHeader("Content-Disposition", "attachment;filename=" + "" + FileName); ctl.Page.EnableViewState = false; System.IO.StringWriter tw = new System.IO.StringWriter(); HtmlTextWriter hw = new HtmlTextWriter(tw); ctl.RenderControl(hw); HttpContext.Current.Response.Write(tw.ToString()); HttpContext.Current.Response.End(); }调用的代码：
- C# code
//这地方有些问题，隐藏某些列（列索引从0开始）的时候，导出的excel会出现乱码 //GridView1.Columns[4].Visible = false;//隐藏选择列，不导出选择列 //GridView1.Columns[5].Visible = false;//隐藏选择列，不导出选择列 GridviewToExcel(GridView1, "jdccx.xls"); GridView1.AllowPaging = true; GridView1.AllowSorting = true; //GridView1.Columns[4].Visible = true;//恢复选择列为可见 //GridView1.Columns[5].Visible = true;//恢复选择列为可见 GridView1.DataBind();
如上，当我把隐藏这两列的代码注释掉，将gridview数据全部导出的时候没问题，如下：
但是我不想要后两列，遍把它们隐藏，导出以后再显示，这时候虽然不把后两列导出了，但是导出的数据出现了乱码（除了日期），如图：
编码方面的问题我想过了，utf-8、unicode、gb2312全试了，不行啊。哪位大神给解答一下，万分感谢
[解决办法]
记事本打开文件，另存为 编码选与页面定义的编码一致
试试
[解决办法]
在绑定数据里进行隐藏式不会乱的啊
[解决办法]
完整的测试例子
- C# code
<%@ Page Language="C#" %><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"><script runat="server"> private System.Data.DataTable GetData() { String[] testData = { "Yes", "No", "" }; System.Data.DataTable dataTable1 = new System.Data.DataTable("BlogUser"); System.Data.DataRow dr; dataTable1.Columns.Add(new System.Data.DataColumn("Id", typeof(System.Int32))); dataTable1.Columns.Add(new System.Data.DataColumn("标题", typeof(System.String))); dataTable1.Columns.Add(new System.Data.DataColumn("State", typeof(System.String))); dataTable1.Columns.Add(new System.Data.DataColumn("负责人", typeof(System.String))); for (int i = 0; i < 8; i++) { dr = dataTable1.NewRow(); dr[0] = i; dr[1] = "标题标题标题标题标题标题标题标题标题标题【孟子E章】" + i.ToString(); dr[2] = testData[i % 3]; dr[3] = "标题标题标题标题标题标题标题标题标题标题【孟子E章】" + i.ToString(); dataTable1.Rows.Add(dr); } return dataTable1; } bool isExport = false; protected void Page_Load(object sender, EventArgs e) { if (!Page.IsPostBack) { isExport = false; GridView1.DataSource = this.GetData(); GridView1.DataBind(); } } public void GridviewToExcel(Control ctl, string FileName) { HttpContext.Current.Response.Charset = "GB2312"; HttpContext.Current.Response.ContentEncoding = System.Text.Encoding.UTF8; HttpContext.Current.Response.ContentType = "application/ms-excel"; HttpContext.Current.Response.AppendHeader("Content-Disposition", "attachment;filename=" + "" + FileName); ctl.Page.EnableViewState = false; System.IO.StringWriter tw = new System.IO.StringWriter(); HtmlTextWriter hw = new HtmlTextWriter(tw); ctl.RenderControl(hw); HttpContext.Current.Response.Write(tw.ToString()); HttpContext.Current.Response.End(); } protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e) { if (isExport) { e.Row.Cells[2].Visible = false; } } public override void VerifyRenderingInServerForm(Control control) { } protected void Button1_Click(object sender, EventArgs e) { isExport = true; GridView1.DataSource = this.GetData(); GridView1.DataBind(); GridviewToExcel(GridView1, "xxx.xls"); }</script><html xmlns="http://www.w3.org/1999/xhtml"><head id="Head1" runat="server"></head><body> <form id="form1" runat="server"> <asp:GridView ID="GridView1" runat="server" OnRowDataBound="GridView1_RowDataBound"> </asp:GridView> <asp:Button ID="Button1" runat="server" OnClick="Button1_Click" Text="导出" /> </form></body></html>