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:@");
    }
}