如何把数据导出成Excel

 public void CreateExcel(DataTable dt,string FileName)
  {
   HttpResponse resp;
   resp=((Page)HttpContext.Current.Handler).Response;
   resp.ContentEncoding = System.Text.Encoding.Default;
   resp.AppendHeader("Content-Disposition", "attachment;filename="+HttpUtility.UrlPathEncode(FileName));
   string colHeaders="";
   string ls_item="";
   int i=0;

   DataRow[] myRow=dt.Select("");

   for(i=0;i<dt.Columns.Count-1;i++)
   {
    colHeaders+=dt.Columns[i].Caption.ToString()+"/t";    
   }
   colHeaders+=dt.Columns[i].Caption.ToString() +"/n";
   resp.Write(colHeaders);

   foreach(DataRow row in myRow)
   {
    for(i=0;i<dt.Columns.Count-1;i++)
    {
     ls_item +=row[i].ToString() + "/t";
    }
    ls_item += row[i].ToString() +"/n";
    resp.Write(ls_item);
    ls_item="";
   }
   resp.End();
  }