ASP.NET导出数据到excel中

 

protected void Button_ExpRecord_Click(object sender, EventArgs e)
    {   

        StringWriter sw = new StringWriter();


        HtmlTextWriter htmlwrite = new HtmlTextWriter(sw);


        string excelName = "个人信息.xls";


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


        Response.AppendHeader("Content-Disposition", "attachment;filename=" + Server.UrlEncode(excelName));

	//GridView_ImportRecord是用来显示要导出到excel的信息
        GridView_ImportRecord.RenderControl(htmlwrite);


        Response.Write(sw.ToString());


        Response.Flush();


        Response.End();
    }


    //此方法不能删除，如果没有下面方法会报错类型“GridView”的控件"ct100_ContentPlaceHolder1_GridView1”必须放在具有 runat=server 的窗体标记内     


    public override void VerifyRenderingInServerForm(Control control)
    {


        // Confirms that an HtmlForm control is rendered for        


        //如果要限制控件必须位于<form runat=server>标记以内，则请先呼叫这个方法，才进行展现，如此一来，如果控件放在标记以外，便会显示错误信息。


    }