怎么将datalist中的数据导入到excel

Question

可以参考gridview的导出excel吧，网上有

Answer 1

通过DataGrid导出..public   static   void   ToExcel(System.Web.UI.Control   ctl,string   FileName)   
                  {   
                          HttpContext.Current.Response.Charset   ="UTF-8";   
                          HttpContext.Current.Response.ContentEncoding   =System.Text.Encoding.Default;   
                          HttpContext.Current.Response.ContentType   ="application/ms-excel";   
                          HttpContext.Current.Response.AppendHeader("Content-Disposition","attachment;filename="+""+FileName+".xls");   
                          ctl.Page.EnableViewState   =false;   
                          System.IO.StringWriter     tw   =   new   System.IO.StringWriter();   
                          System.Web.UI.HtmlTextWriter   hw   =   new   System.Web.UI.HtmlTextWriter(tw);   
                          ctl.RenderControl(hw);   
                          HttpContext.Current.Response.Write(tw.ToString());   
                          HttpContext.Current.Response.End();   
                  }     
    
  ToExcel(DataGrid1,"dgExcel");