表格控件或table轉excel檔的代碼

1. Response.Clear();
2. Response.Buffer = true;
3. HttpContext.Current.Response.AppendHeader("Content-Disposition", "attachment;filename=TicketVisaMoneyDetail.xls;");
4. HttpContext.Current.Response.Charset = "UTF-8";
5. HttpContext.Current.Response.ContentEncoding = System.Text.Encoding.GetEncoding(936);//936是專門處理中文字符集的
6. HttpContext.Current.Response.ContentType = "application/ms-excel";//image/JPEG;text/HTML;image/GIF;vnd.ms-excel/msword 
7.         
8. System.IO.StringWriter tw = new System.IO.StringWriter();
9. System.Web.UI.HtmlTextWriter hw = new System.Web.UI.HtmlTextWriter(tw);
10.        
11. this.tblCallableMoney.Page.EnableViewState = false;//如果轉檔出來的table有分頁，要加此句
12. this.Bind_tblCallableMoney();
13.         
14. //當用了母版頁時，要加這一段
15. HtmlForm frm = new HtmlForm();
16. this.tblCallableMoney.Parent.Controls.Add(frm);
17. frm.Attributes["runat"] = "server";
18. frm.Controls.Add(this.lblTitle);//轉檔出來後的標題
19. frm.Controls.Add(this.tblCallableMoney);
20. frm.RenderControl(hw);
22. HttpContext.Current.Response.Write(tw.ToString());
23. HttpContext.Current.Response.End();