#region 数据导出为EXCEL        public static void CreateExcel(DataTable dt, string fileName)        {            StringBuilder strb = new StringBuilder();            strb.Append(" ");            strb.Append("  
     ");            strb.Append(" ");            strb.Append(" 
     
      ");            strb.Append(" 
      
       ");            strb.Append(" 
       
        ");            strb.Append(" 
        
         ");            strb.Append(" 
         
          " + fileName + "
         ");            strb.Append(" 
         
          ");            strb.Append(" 
          
           285
          ");            strb.Append(" 
          ");            strb.Append(" 
          
           "); strb.Append(" 
           
            "); strb.Append(" 
            
             3
            "); strb.Append(" 
            
             1
            "); strb.Append(" 
           "); strb.Append(" 
          ");            strb.Append(" 
          
           False
          ");            strb.Append(" 
          
           False
          ");            strb.Append(" 
          
           False
          ");            strb.Append(" 
         ");            strb.Append(" 
        ");            strb.Append(" 
        
         6750
        ");            strb.Append(" 
        
         10620
        ");            strb.Append(" 
        
         480
        ");            strb.Append(" 
        
         75
        ");            strb.Append(" 
        
         False
        ");            strb.Append(" 
        
         False
        ");            strb.Append(" 
       
      ");            strb.Append(" 
     ");            strb.Append("");            strb.Append("   
     
      ");            if (dt.Rows.Count > 0)            {                strb.Append("
        ");                //写列标题                   int columncount = dt.Columns.Count;                for (int columi = 0; columi < columncount; columi++)                {                    strb.Append(" 
");                }                strb.Append(" 
");                //写数据                   for (int i = 0; i < dt.Rows.Count; i++)                {                    strb.Append(" 
        ");                    for (int j = 0; j < dt.Columns.Count; j++)                    {                        strb.Append(" 
");                    }                    strb.Append(" 
");                }            }            strb.Append("
" + ColumnName(dt.Columns[columi].ToString()) + "
" + dt.Rows[i][j].ToString() + "
  ");            HttpContext.Current.Response.Clear();            HttpContext.Current.Response.Buffer = true;            HttpContext.Current.Response.Charset = "utf-8";            HttpContext.Current.Response.AddHeader("Content-Disposition", "attachment; filename=" + fileName + ".xls");            HttpContext.Current.Response.ContentEncoding = System.Text.Encoding.UTF8;//             HttpContext.Current.Response.ContentType = "application/ms-excel";//设置输出文件类型为excel文件。             //HttpContext.Current.p.EnableViewState = false;            HttpContext.Current.Response.Write(strb);            HttpContext.Current.Response.End();        }        #endregion

http://www.cnblogs.com/yuangang/p/5477324.html