/// <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})");
}