CSVHelper转换csv为DataTable

483 阅读1分钟

在安装Nuget包:CsvHelper的情况下, 通过以下代码进行读取

            var dataTable = new DataTable();
            using (var reader = new StreamReader(YourCsvFile))
            using (var csv = new CsvReader(reader, new CsvConfiguration(CultureInfo.InvariantCulture) { Mode = CsvMode.RFC4180 }))
            {
                // Do any configuration to `CsvReader` before creating CsvDataReader.
                using (var dataReader = new CsvDataReader(csv))
                {
                    dataTable = new DataTable();
                    dataTable.Load(dataReader);
                }
            }