C#编写GridView导出EXCEL

最新推荐文章于 2022-02-18 13:29:33 发布

shenyi007

最新推荐文章于 2022-02-18 13:29:33 发布

阅读量4.1k

点赞数

文章标签： c# button excel object server asp

本文链接：https://blog.youkuaiyun.com/shenyi007/article/details/1742266

版权

2个控件，Button，GridView（ID改为GV2）

Button代码如下：

protected void Button5_Click(object sender, EventArgs e)
{

//Excel
        Response.Clear();
        Response.Buffer = true;
        Response.Charset = "GB2312";
        Response.AppendHeader("Content-Disposition", "attachment;filename=FileName.xls");
        Response.ContentEncoding = System.Text.Encoding.GetEncoding("GB2312");//设置输出流为简体中文
        Response.ContentType = "application/ms-excel";//设置输出文件类型为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);//GV2是Gridview的ID名称
        Response.Write(oStringWriter.ToString());
        Response.End();

}

public override void VerifyRenderingInServerForm(Control control)
{
}

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

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

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