Aspx頁面匯出Excel

 string name1=DateTime.Today.ToString("yyyyMMdd")+new Random(DateTime.Now.Millisecond).Next(10000).ToString();

Response.Clear(); 

Response.Buffer= true; 

Response.Charset="Big5"; 

Response.AppendHeader("Content-Disposition","attachment;filename="+name1+"info.xls"); 

Response.ContentEncoding=System.Text.Encoding.GetEncoding("Big5");

Response.ContentType = "application/ms-excel";

this.EnableViewState = false;    

System.Globalization.CultureInfo myCItrad = new System.Globalization.CultureInfo("ZH-CN",true);

System.IO.StringWriter oStringWriter = new System.IO.StringWriter(myCItrad); 

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

this.obj_result1.RenderControl(oHtmlTextWriter); 

Response.Write(oStringWriter.ToString());

Response.End();