优化了一下Gridview导出EXCEL的代码，现在导出的Excel是正确的格式

最新推荐文章于 2024-11-08 20:25:11 发布

shenyi007

最新推荐文章于 2024-11-08 20:25:11 发布

阅读量493

点赞数

文章标签： excel 优化 button object server asp

本文链接：https://blog.csdn.net/shenyi007/article/details/2074751

版权

Button代码如下：

protected void Button5_Click(object sender, EventArgs e)
{

//Excel
Response.Clear();
Response.Buffer = true;
Response.Charset = "GB2312";
Response.AppendHeader("Content-Disposition", "attachment;filename=" + tb.text.trim().tostring() + ".xls");
Response.ContentEncoding = System.Text.Encoding.UTF7;
Response.ContentType = "application/ms-excel";
this.EnableViewState = false;
System.Globalization.CultureInfo myCItrad = new System.Globalization.CultureInfo("ZH-CN", true);
System.IO.StringWriter oStringWriter = new System.IO.StringWriter(myCItrad);
System.Web.UI.HtmlTextWriter oHtmlTextWriter = new System.Web.UI.HtmlTextWriter(oStringWriter);
this.GV2.RenderControl(oHtmlTextWriter);
Response.Output.Write(oStringWriter.ToString());
Response.Flush();
Response.End();

}

public override void VerifyRenderingInServerForm(Control control)
{
}

另外，ASP页面头代码需要修改为

<%@ Page Language="C#" EnableEventValidation="false">

否则会提示Gridview中的控件GV2需要在runat=server内。