你现在查看的是CsvHelper.cs类的源码

view plainprint?
  1.  /// <summary>  
  2. /// 联系方式：361983679    
  3. /// 更新网站：http://www.sufeinet.com/thread-655-1-1.html  
  4. /// </summary>  
  5. using System.Data;  
  6. using System.IO;  
  7.   
  8. namespace DotNet.Utilities  
  9. {  
  10.     /// <summary>  
  11.     /// CSV文件转换类  
  12.     /// </summary>  
  13.     public static class CsvHelper  
  14.     {  
  15.         /// <summary>  
  16.         /// 导出报表为Csv  
  17.         /// </summary>  
  18.         /// <param name="dt">DataTable</param>  
  19.         /// <param name="strFilePath">物理路径</param>  
  20.         /// <param name="tableheader">表头</param>  
  21.         /// <param name="columname">字段标题,逗号分隔</param>  
  22.         public static bool dt2csv(DataTable dt, string strFilePath, string tableheader, string columname)  
  23.         {  
  24.             try  
  25.             {  
  26.                 string strBufferLine = "";  
  27.                 StreamWriter strmWriterObj = new StreamWriter(strFilePath, false, System.Text.Encoding.UTF8);  
  28.                 strmWriterObj.WriteLine(tableheader);  
  29.                 strmWriterObj.WriteLine(columname);  
  30.                 for (int i = 0; i < dt.Rows.Count; i++)  
  31.                 {  
  32.                     strBufferLine = "";  
  33.                     for (int j = 0; j < dt.Columns.Count; j++)  
  34.                     {  
  35.                         if (j > 0)  
  36.                             strBufferLine += ",";  
  37.                         strBufferLine += dt.Rows[i][j].ToString();  
  38.                     }  
  39.                     strmWriterObj.WriteLine(strBufferLine);  
  40.                 }  
  41.                 strmWriterObj.Close();  
  42.                 return true;  
  43.             }  
  44.             catch  
  45.             {  
  46.                 return false;  
  47.             }  
  48.         }  
  49.   
  50.         /// <summary>  
  51.         /// 将Csv读入DataTable  
  52.         /// </summary>  
  53.         /// <param name="filePath">csv文件路径</param>  
  54.         /// <param name="n">表示第n行是字段title,第n+1行是记录开始</param>  
  55.         public static DataTable csv2dt(string filePath, int n, DataTable dt)  
  56.         {  
  57.             StreamReader reader = new StreamReader(filePath, System.Text.Encoding.UTF8, false);  
  58.             int i = 0, m = 0;  
  59.             reader.Peek();  
  60.             while (reader.Peek() > 0)  
  61.             {  
  62.                 m = m + 1;  
  63.                 string str = reader.ReadLine();  
  64.                 if (m >= n + 1)  
  65.                 {  
  66.                     string[] split = str.Split(',');  
  67.   
  68.                     System.Data.DataRow dr = dt.NewRow();  
  69.                     for (i = 0; i < split.Length; i++)  
  70.                     {  
  71.                         dr[i] = split[i];  
  72.                     }  
  73.                     dt.Rows.Add(dr);  
  74.                 }  
  75.             }  
  76.             return dt;  
  77.         }  
  78.     }  
  79. }