/// <summary> /// Read a CSV file into a table /// </summary> /// <param name="filename">Filename of CSV file</param> /// <param name="headerRow">True if the first row contains column names</param> /// <param name="scanRows">The number of rows to scan for types when building a DataTable (0 to scan the whole file)</param> /// <returns>System.Data.DataTable object that contains the CSV data</returns> public static DataTable ReadCSVFile(string filename, bool headerRow, int scanRows, string delimiter = ",") { using (CSVReader reader = new CSVReader(new FileInfo(filename))) { reader.ScanRows = scanRows; return reader.CreateDataTable(headerRow, delimiter); } }
/// <summary> /// Read a CSV file into a table /// </summary> /// <param name="filename">Filename of CSV file</param> /// <param name="headerRow">True if the first row contains column names</param> /// <returns>System.Data.DataTable object that contains the CSV data</returns> public static DataTable ReadCSVFile(string filename, bool headerRow) { using (CSVReader reader = new CSVReader(new FileInfo(filename))) return reader.CreateDataTable(headerRow); }