public void CanCountColumnsOnFirstRow()
{
var path = Path.GetDirectoryName(Assembly.GetExecutingAssembly().Location);
var reader = new ExcelFileReader(path + "\\BrickRepoTests_BrickList01.xlsx");
reader.SetActiveSheet("ElementData");
reader.ReadRow();
Assert.That(reader.GetColumnCount(), Is.EqualTo(5));
}
public void WillReturnFalseIfColumnDoesntExist()
{
var path = Path.GetDirectoryName(Assembly.GetExecutingAssembly().Location);
var reader = new ExcelFileReader(path + "\\BrickRepoTests_BrickList01.xlsx");
reader.SetActiveSheet("ElementData");
reader.ReadRow();
Assert.That(reader.GetColumnCount(), Is.EqualTo(5));
string result = "";
Assert.That(reader.ReadColumnAsText(8, out result), Is.False);
Assert.That(result, Is.EqualTo(""));
}
public void CanReadSeveralRows()
{
var path = Path.GetDirectoryName(Assembly.GetExecutingAssembly().Location);
var reader = new ExcelFileReader(path + "\\BrickRepoTests_BrickList01.xlsx");
reader.SetActiveSheet("ElementData");
reader.ReadRow();
Assert.That(reader.GetColumnCount(), Is.EqualTo(5));
string result = "";
Assert.That(reader.ReadColumnAsText(0, out result), Is.True);
Assert.That(result, Is.EqualTo("MaterialID"));
reader.ReadRow();
Assert.That(reader.ReadColumnAsText(0, out result), Is.True);
Assert.That(result, Is.EqualTo("28"));
reader.ReadRow();
Assert.That(reader.ReadColumnAsText(0, out result), Is.True);
Assert.That(result, Is.EqualTo("37"));
}