现在的位置: 首页 > 综合 > 正文

GridView 技巧3:将GridView数据导出到excel文件

2013年06月23日 ⁄ 综合 ⁄ 共 781字 ⁄ 字号 评论关闭

在页面添加一个ID为ExportToExcelBtn的按钮,代码部分如下:

protected void ExportToExcelBtn_Click(object sender, EventArgs e)
    {
        Response.Clear();
        Response.AddHeader("content-disposition", "attachment;filename=lessons.xls");
        Response.Charset = "gb2312";
        Response.ContentType = "application/vnd.xls";
        System.IO.StringWriter stringWrite = new System.IO.StringWriter();
        System.Web.UI.HtmlTextWriter htmlWrite = new HtmlTextWriter(stringWrite);

        gvLessons.AllowPaging = false;
        gvLessons.DataBind();
        gvLessons.RenderControl(htmlWrite);

        Response.Write(stringWrite.ToString());
        Response.End();

        gvLessons.AllowPaging = true;
        gvLessons.DataBind();
    }
 要重载VerifyRenderingInServerForm方法,不然将报错
    public override void VerifyRenderingInServerForm(Control control) { }

抱歉!评论已关闭.