[asp.net]把gridview的数据导入excel

完整的代码

 

using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
   using System.Web.UI.HtmlControls;

public partial class _Default : System.Web.UI.Page  
{ 
    protected void Button2_Click(object sender, EventArgs e) 
    { 
        Response.ClearContent(); 
        Response.Write("<meta http-equiv=Content-Type content=text/html;charset=utf-8>"); 
        string excelFileName = "Excel.xls"; 
        Response.AddHeader("content-disposition", "attachment;filename=" + Server.UrlEncode(excelFileName)); 
        Response.ContentType = "application/excel"; 
        System.IO.StringWriter stringWrite = new System.IO.StringWriter(); 
        System.Web.UI.HtmlTextWriter htmlWrite = new HtmlTextWriter(stringWrite); 
        GridView1.RenderControl(htmlWrite); 
        Response.Write(stringWrite.ToString()); 
        Response.End(); 
    } 
 
    public override void VerifyRenderingInServerForm(Control control)    
    { 
        //处理 'GridView' 必须置于有 runat=server 的表单标记之中 的错误  
    }    
}

http://www.dotblogs.com.tw/chou/archive/2009/04/03/7831.aspx