将gridview中的数据导出到excel中

来源：互联网发布：oss js 上传文件跨域编辑：程序博客网时间：2024/05/02 03:01

protected void Button1_Click(object sender, EventArgs e)
    {
        string strFileName = DateTime.Now.ToString("yyyyMMdd-hhmmss");
        string style = @"<style> .text { mso-number-format:/@; } </style> ";
        System.Web.HttpContext HC = System.Web.HttpContext.Current;
        HC.Response.Clear();
        HC.Response.Buffer = true;
        //导出为excel
        HC.Response.AddHeader("Content-Disposition", "attachment;filename=" + HttpUtility.UrlEncode(strFileName, System.Text.Encoding.UTF8) + ".xls");

HC.Response.ContentType = "application/vnd.xls";

        //HC.Response.ContentType = "application/ms-excel";//设置导出文件的格式
        Response.ContentEncoding = System.Text.Encoding.UTF8;//设置输出流为简体中文
        #region 导出为word
        //HC.Response.AddHeader("Content-Disposition", "attachment;filename=" + HttpUtility.UrlEncode(strFileName, System.Text.Encoding.UTF8) + ".doc");
        //HC.Response.ContentType = "application/ms-word";//设置输出文件类型为Word文件。
        #endregion

        EnableViewState = false;
        StringWriter sw = new StringWriter();
        HtmlTextWriter htw = new HtmlTextWriter(sw);
        this.GridView1.AllowPaging = false;
        BindGridView();

        this.GridView1.RenderControl(htw);
        HC.Response.Write(style);
        HC.Response.Write(sw.ToString());
        HC.Response.End();

this.GridView1.AllowPaging = true;
BindGridView();

}

报错：类型“GridView”的控件“GridView1”必须放在具有 runat=server 的窗体标记内

解决：添加事件
    public override void VerifyRenderingInServerForm(Control control)
    {
    }

报错：只能在执行 Render() 的过程中调用 RegisterForEventValidation

解决：将asp页面的

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="JBZ_DailyReport.aspx.cs" Inherits="_Default" %>

改成

<%@ Page Language="C#" EnableEventValidation = "false" AutoEventWireup="true" CodeFile="JBZ_DailyReport.aspx.cs" Inherits="_Default" %>

奋斗了一天终于弄出来，(*^__^*)