public void TestDataTable()
{
using (var mem = new FileStream("CSVs//test1.csv", FileMode.Open))
using (var csvr = new CsvReader.CsvReader(mem))
{
int rowCount = 0;
foreach (var dr in csvr.Rows())
{
rowCount++;
if (dr[0].ToString() == "1")
{
Assert.IsTrue(dr[1].ToString() == "one");
}
if (dr[0].ToString() == "2")
{
Assert.IsTrue(dr[1].ToString() == "two");
Assert.IsTrue(dr["x"].ToString() == "comma,here");
Assert.IsTrue(dr["y"].ToString() == "new line\r\nhere");
Assert.IsTrue(dr["z"].ToString() == "double\"quote");
}
if (dr[0].ToString() == "3")
{
Assert.IsTrue(dr[1].ToString() == "three");
}
Assert.IsTrue(dr.ItemArray.Length == 7);
}
Assert.IsTrue(rowCount == 3);
}
}
public void TestDataTable_EmptyLine()
{
using (var mem = new FileStream("CSVs//test2.csv", FileMode.Open))
using (var csvr = new CsvReader.CsvReader(mem))
{
int rowCount = 0;
foreach (var dr in csvr.Rows())
{
rowCount++;
Assert.IsTrue(dr.ItemArray.Length == 7);
}
Assert.IsTrue(rowCount == 3);
}
}
