GridView資料匯出功能

匯出成xls檔案用excel開啟。通用的代碼如下：

 

 #region 匯出
        //common
        public void ExcuteOut(GridView gv)
        {
            if (gv.Rows.Count > 0)
            {
                Response.ClearContent();
                Response.AddHeader("content-disposition", "attachment; filename=DMReport" + DateTime.Now.ToString("_yyyyMMdd_HHmmss") + ".xls");
                Response.ContentEncoding = System.Text.Encoding.UTF8;
                Response.ContentType = "application/excel";
                StringWriter sw = new StringWriter();
                HtmlTextWriter htw = new HtmlTextWriter(sw);
                gv.RenderControl(htw);
                Response.Write(sw.ToString());
                Response.End();
            }
            else
            {
                Tools.Alert(Page, "沒有資料!");
            }
        }
        public override void VerifyRenderingInServerForm(Control control)
        { }
        #endregion

 

 必須加上後面的VerifyRenderingInServerForm函數，否則會報錯。

注意要使用utf8編碼，不能用default。