导出excel文件问题

[yinmo1988]

我在项目中要有一个导出（打印）成Excel的功能，这个Excel要在客户端那边生成，不是在我们服务器生成，这个功能怎么实现，请发下代码。。谢谢

[智者知已应修善业]

protected void Chu_Click()//导出数据
    {
        Response.Clear();
        Response.AddHeader("content-disposition", "attachment;filename=" + FileName + ".xls");
        Response.Charset = "";
        Response.ContentType = "application/vnd.xls";
        System.IO.StringWriter stringWrite = new System.IO.StringWriter();
        System.Web.UI.HtmlTextWriter htmlWrite = new HtmlTextWriter(stringWrite);
        DataList1.RenderControl(htmlWrite);
        DataList3.RenderControl(htmlWrite);
        Response.Write(stringWrite.ToString());
        Response.End();
    }

[智者知已应修善业]

http://blog.csdn.net/xianfajushi/archive/2009/11/18/4830278.aspx

[YnSky]

        this.GridView1.AllowPaging = false;
        Bindcontrols.BindGridView(GridView1, selecttext);//重新绑定
        Response.ClearContent();
        Response.AppendHeader("Content-Disposition", "attachment;filename=" + System.Web.HttpUtility.UrlEncode("名字", System.Text.Encoding.UTF8) + ".xls");
        Response.ContentType = "application/excel";
        StringWriter sw = new StringWriter();
        HtmlTextWriter htw = new HtmlTextWriter(sw);
        GridView1.Columns[GridView1.Columns.Count - 1].Visible = false; //控制列的隐藏显示
        this.GridView1.HeaderRow.BackColor = System.Drawing.Color.FromName("#ffffff");
        this.GridView1.FooterRow.BackColor = System.Drawing.Color.FromName("#ffffff");
        this.GridView1.FooterRow.BorderColor = System.Drawing.Color.FromName("#ffffff");
        this.GridView1.RenderControl(htw);
        Response.Write(sw.ToString());
        Response.End();
        this.GridView1.AllowPaging = true;