【筆記】ASP.NET 從 GridView 匯出Excel檔

最近的一直在重覆這些動作, 直接整理成 Function, 塞入 Command 就可以用比較方便

/* 匯出Excel檔 */

protected void getExcelButton_Click(object sender, EventArgs e)
{
    Response.ClearContent();
    Response.Write("<meta http-equiv=Content-Type 
        content=text/html;charset=utf-8>");
    /* 要匯出旳檔案名稱 */
    string excelFileName = "HistoryData.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();
}

/* 沒加這個 Function 之前會一直看到 */
/* "GridView 必須置於有runat=server 的表單標記之中" */
/* 點選後會直接另存Excel檔 */

public override void VerifyRenderingInServerForm(Control control)
{
}