/// <summary>
/// 读取CSV文件到DataTable中
/// </summary>
/// <param name="filePath">CSV的文件路径</param>
/// <returns></returns>
public static List <List <object> > ReadCSV(string filePath)
{
List <List <object> > res = new List <List <object> >();
using (CsvFileReader reader = new CsvFileReader(filePath))
{
CsvRow row = new CsvRow();
while (reader.ReadRow(row))
{
res.Add(row.Cast <object>().ToList());
//res.Add(row.Select(s => s.Replace("\"", "")).Cast<object>().ToList());
}
}
return(res);
}