Asp.Net資料導出Excel報表

1锛?瀵煎?哄?ㄩ??TML ?版????Excel

杩?绉??規???灏?Html涓?????????妗ｅ??瀹癸?????????锛?琛ㄦ?鹼??劇??绛?????椤甸?㈠??瀹瑰?煎?轟負 Excel

Response.Clear();     
Response.Buffer = true;     
Response.AppendHeader("Content-Disposition","attachment;filename="+DateTime.
Now.ToString("yyyyMMdd")+".xls");           
Response.ContentEncoding = System.Text.Encoding.UTF8;   
Response.ContentType = ""application/ms-excel";   
this.EnableViewState = false;
           

2:浠?GridView?т歡?存?ュ?煎?烘?版????xcel

瀵煎??ridView涓????版????

public void ExportToExcel(GridView ctl) 
  {
   Response.Clear();
   Response.Buffer = true;
   Response.Charset = "gb2312";
   Response.AppendHeader("Content-Disposition", "attachment;filename=?????ヨ〃.xls");
   Response.ContentEncoding = System.Text.Encoding.GetEncoding("gb2312");
   Response.ContentType = "application/vnd.ms-excel"; 
   ctl.Page.EnableViewState = false; 
   System.IO.StringWriter tw = new System.IO.StringWriter(); 
   System.Web.UI.HtmlTextWriter hw = new HtmlTextWriter(tw); 
   ctl.RenderControl(hw);
   
   Response.Write(tw.ToString()); 
   Response.End();
  }
           

3涔????芥??DataTable ,DataSet,datagrid绛?

private void ToExcel(Control ctl, string FileName)
        {
            HttpContext.Current.Response.ContentEncoding = System.Text.Encoding.GetEncoding("GB2312");
            HttpContext.Current.Response.Charset = "GB2312";
            HttpContext.Current.Response.ContentType = "application/ms-excel";
            HttpContext.Current.Response.AppendHeader("Content-Disposition", "attachment;filename=" + "" + FileName);
            ctl.Page.EnableViewState = false;
            System.IO.StringWriter tw = new System.IO.StringWriter();
            HtmlTextWriter hw = new HtmlTextWriter(tw);
            ctl.RenderControl(hw);
            HttpContext.Current.Response.Write(tw.ToString());
            HttpContext.Current.Response.End();
        }