解决gridview导出到excel中汉字出现乱码的问题

我在用下面代码将gridview导出到excel中时，其中的汉字出现了乱码：

protectedvoidButton2_Click(objectsender,EventArgse)

{

GridView1.Focus();

Response.Clear();

Response.Buffer=false;

Response.Charset="GB2312";

Response.AppendHeader("Content-Disposition","attachment;filename=pickmorv.xls");

Response.ContentEncoding=System.Text.Encoding.GetEncoding("GB2312");

Response.ContentType="application/ms-excel";

this.EnableViewState=false;

System.IO.StringWriteroStringWriter=newSystem.IO.StringWriter();

HtmlTextWriteroHtmlTextWriter=newHtmlTextWriter(oStringWriter);

GridView1.RenderControl(oHtmlTextWriter);

Response.Write(oStringWriter.ToString());

Response.End();

}

publicoverridevoidVerifyRenderingInServerForm(Controlcontrol)

{

//base.VerifyRenderingInServerForm(control);

}

使用下列代码时解决了问题：

#region//将某天的详细数据导出到EXCEL

protectedvoidButton3_Click(objectsender,EventArgse)

{

Response.Clear();

Response.Buffer=false;

Response.Charset="GB2312";

Response.AppendHeader("Content-Disposition","attachment;filename=pkmv_de.xls");

Response.ContentEncoding=System.Text.Encoding.GetEncoding("GB2312");

Response.ContentType="application/ms-excel";

Response.Write("<metahttp-equiv=Content-Typecontent=\"text/html;charset=GB2312\">");

this.EnableViewState=false;

System.IO.StringWriteroStringWriter=newSystem.IO.StringWriter();

HtmlTextWriteroHtmlTextWriter=newHtmlTextWriter(oStringWriter);

GridView2.RenderControl(oHtmlTextWriter);

Response.Write(oStringWriter.ToString());

Response.End();

}

publicoverridevoidVerifyRenderingInServerForm(Controlcontrol)

{

//base.VerifyRenderingInServerForm(control);

}

#endregion

本文转自fengyp 51CTO博客，原文链接：/fengyp/51812，如需转载请自行联系原作者