using System;
using System.Collections.Generic;
using System.Data;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.IO;


namespace CommonLib.DataFile
{
    public class CSVFile
    {
        //将CSV文件转换为DataTable
        public static void ReadCSVFile(DataTable Table, string Filename,Boolean bWithHead =false )
        { 
            //string[] lines = Filename.Split(new char[] { '\r', '\n'})
            string[] contents = File.ReadAllLines(Filename);
            if(bWithHead)
            {
                Table.Columns.Clear();
                string[] colNames = contents[0].Split(',');
                foreach(var colName in colNames)
                {
                    Table.Columns.Add(colName);
                } 
            }  
            int colCount = Table.Columns.Count;
            for(int i=0;i<contents.Length;i++)
            {
                if(i==0&&bWithHead)
                {
                    continue;
                } 
                string[] rowValues = contents[i].Split(',');
                DataRow row = Table.NewRow();
                for(int j=0;j<rowValues.Length;j++)
                {
                    if (j == colCount)
                    {
                        break;
                    }
                    row[j] = rowValues[j];
                }
                Table.Rows.Add(row); 
            } 
                 
        }
    }
}