C#利用LumenWorks.Framework.IO.Csv讀取CSV檔案

標籤：blog   ar   io   os   sp   for   檔案   div   log   

 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;                    }                }            }        }

　　需要引用LumenWorks.Framework.IO.dll，讀取的時候編碼格式要選對，否則會亂碼，表頭自己設定

C#利用LumenWorks.Framework.IO.Csv讀取CSV檔案