gridview导出excel乱码有关问题。全部数据导出的时候不乱码，但是隐藏部分列不想导出的时候乱码

2012-08-08

gridview导出excel乱码问题。全部数据导出的时候不乱码，但是隐藏部分列不想导出的时候乱码用到的导出代码：C

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>

热点排行

asp.net

gridview导出excel乱码有关问题。全部数据导出的时候不乱码，但是隐藏部分列不想导出的时候乱码