随笔- 62 文章- 0 评论- 1 阅读- 55044

C#利用LumenWorks.Framework.IO.Csv读取CSV文件

static DataTable GetData(Stream stream)
       {
           using (stream)
           {
               using (StreamReader input = new StreamReader(stream, Encoding.GetEncoding("shift_jis")))
               {
                   using (CsvReader csv = new CsvReader(input, false))
                   {
                       DataTable dt = new DataTable();
                       int columnCount = csv.FieldCount;
                       for (int i = 0; i < columnCount; i++)
                       {
                           dt.Columns.Add("col" + i.ToString());
                       }
 
                       while (csv.ReadNextRecord())
                       {
                           DataRow dr = dt.NewRow();
                           for (int i = 0; i < columnCount; i++)
                           {
                               if (!string.IsNullOrWhiteSpace(csv[i]))
                               {
                                   dr[i] = csv[i];
                               }
                           }
                           dt.Rows.Add(dr);
                       }
                       return dt;
                   }
 
               }
           }
       }