asp.net 将内容导出EXCEL文件(转)

using System;
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 test : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {


        if (!Page.IsPostBack)
        {
            databind();
        }


    }

    public override void VerifyRenderingInServerForm(Control control)
    {
        //base.VerifyRenderingInServerForm(control);
    }

    protected void databind()
    {
        DataTable ddt = new DataTable("newExcel");
        ddt.Columns.Add("A", typeof(string));
        ddt.Columns.Add("B", typeof(string));
        ddt.Columns.Add("C", typeof(string));
        Random ro = new Random();
        for (int i = 1; i < 2000; i++)
        {
            DataRow DR = ddt.NewRow();
            DR["A"] = "000" + (czi(i));
            string password=ro.Next(100, 9999).ToString();
            DR["B"] = password;
            DR["C"] =System.Web.Security.FormsAuthentication.HashPasswordForStoringInConfigFile(password, "md5");
            ddt.Rows.Add(DR);


        }

        this.grdExcel.DataSource = ddt.DefaultView;
        this.grdExcel.DataBind();
    }
    protected string czi(int j)
    {
        string jj = string.Empty;
        if(j<10)
        jj= "000"+j.ToString();
        else if(j<99)
        jj= "00" + j.ToString();
        else if(j<999)
        jj= "0" + j.ToString();
        else if(j<9999)
        jj= j.ToString();

return jj;
}

    protected void Button1_Click(object sender, EventArgs e)
    {
        Response.Clear();
        Response.Buffer = true;
        Response.Charset = "gb2312";

//下面这行很重要， attachment 参数表示作为附件下载，您可以改成 online在线打开

        //filename=FileFlow.xls 指定输出文件的名称，注意其扩展名和指定文件类型相符，可以为：.doc || .xls || .txt ||.htm
        string strHeader = "Card";
        Response.AppendHeader("Content-Disposition", "attachment;filename=" + strHeader + ".xls");
        Response.ContentEncoding = System.Text.Encoding.GetEncoding("gb2312");

//Response.ContentType指定文件类型可以为application/ms-excel || application/ms-word || application/ms-txt || application/ms-html || 或其他浏览器可直接支持文档

Response.ContentType = "application/ms-excel";
// this.EnableViewState = false;

//　二、定义一个输入流

System.IO.StringWriter oStringWriter = new System.IO.StringWriter();
System.Web.UI.HtmlTextWriter oHtmlTextWriter = new System.Web.UI.HtmlTextWriter(oStringWriter);

//　三、将目标数据绑定到输入流输出

//oHtmlTextWriter.WriteEncodedText(Server.UrlDecode(strHeader));
grdExcel.RenderControl(oHtmlTextWriter);

//this 表示输出本页，你也可以绑定datagrid,或其他支持obj.RenderControl()属性的控件

        Response.Write(oStringWriter.ToString());
        Response.End();
    }
    protected void grdExcel_RowDataBound(object sender, GridViewRowEventArgs e)
    {

        e.Row.Cells[0].Attributes.Add("style", "vnd.ms-excel.numberformat:@");
        e.Row.Cells[1].Attributes.Add("style", "vnd.ms-excel.numberformat:@");
        e.Row.Cells[2].Attributes.Add("style", "vnd.ms-excel.numberformat:@");
    }
}