/// <summary> /// /// </summary> /// <param name="strCSV"></param> /// <param name="headerRow"></param> /// <param name="scanRows"></param> /// <param name="displayRows"></param> /// <returns></returns> public static DataTable CreateDataTable(string strCSV, bool headerRow = true, int scanRows = 0, int displayRows = 0) { var config = new CsvReaderV2Config() { IncludeHeaders = true, DisplayRows = displayRows }; using (CsvReaderV2 csv = new CsvReaderV2(config)) { return(csv.CreateDataTable(strCSV)); } }
private DataTable LoadFile(string path) { var text = File.ReadAllText(path); var dt = new DataTable(); using (var csv = new CsvReaderV2()) { dt = csv.CreateDataTable(text); } return(dt); }
public void CsvReaderV2_CreateDataTable_ConfigDisplkayRows0NoHeaders_CsvString_ReturnsDataTableWith1Row() { //Prep var csvText = GetCsvStringAdvanced(); var config = new CsvReaderV2Config() { IncludeHeaders = false, DisplayRows = 0 }; var csv = new CsvReaderV2(config); //Action var dt = csv.CreateDataTable(csvText); //Assert Assert.IsTrue(dt.Rows.Count == 1); }
public void CsvReaderV2_CreateDataTable_ConfigDefault_CsvString_ReturnsDataTableWithAllRows() { //Prep var csvText = GetCsvStringAdvanced(); var config = new CsvReaderV2Config() { }; var dt = new DataTable(); using (var csv = new CsvReaderV2(config)) { //Action dt = csv.CreateDataTable(csvText); } //Assert Assert.IsTrue(dt.Rows.Count == 5, message: $"Rows({dt.Rows.Count}) Cols({dt.Columns.Count})"); }
public void CsvReaderV2MbctOnly_CreateDataTableLegacy_Input_Returns() { //Prep var csvText = File.ReadAllText(GetTestDataPath("CSV_Advanced04_LotsOfStuff.txt")); var config = new CsvReaderV2Config() { }; var dt = new DataTable(); using (var csv = new CsvReaderV2(config)) { //Action #pragma warning disable CS0618 // Obsolete Attribbute on method call dt = csv.CreateDataTable(csvText, headerRow: true, displayRows: -1); #pragma warning restore CS0618 // Obsolete Attribbute on method call } //Assert Assert.IsTrue(dt.Rows.Count == 5, message: $"Rows({dt.Rows.Count}) Cols({dt.Columns.Count})"); }