CsvHelper可以方便的处理Csv文件, CsvHelper可以从NuGet上下载
用法示例1:
var table = new DataTable();
var csvFile = Directory.GetCurrentDirectory() + @"\test.csv";
Dictionary<string, Type> TypeMappings = new Dictionary<string, Type>();
using (var reader = File.OpenText(csvFile))
{
using (var csv = new CsvHelper.CsvReader(reader, CultureInfo.InvariantCulture))
using (var dataReader = new CsvHelper.CsvDataReader(csv))
{
table.Load(dataReader);
}
}
var boys = table.Rows.Cast<DataRow>().Where(r => r["Sex"].ToString() == "boy");
foreach (var boy in boys)