public void ThenItShouldContainRowsForItemsAndOneForHeader(int p0, int p1)
{
SpreadsheetStream.Seek(0, SeekOrigin.Begin);
ExcelLoader.LoadReadOnlyFromStream(SpreadsheetStream)
.ReadRows()
.Count.Should().Be(p0);
}
public void ThenEachRowShouldCorrespondToTheDataInTheList()
{
SpreadsheetStream.Seek(0, SeekOrigin.Begin);
var rows = ExcelLoader.LoadReadOnlyFromStream(SpreadsheetStream)
.ReadRows()
.ToArray();
//The first row is the titles so we kip it
for (int i = 1; i < rows.Length; i++)
{
rows[i].Any(x => x.ValueType == typeof(long) && x.Value == ToStore[i - 1].ID).Should().BeTrue();
rows[i].Any(x => x.ValueType == typeof(string) && x.Value == ToStore[i - 1].Title).Should().BeTrue();
rows[i].Any(x => x.ValueType == typeof(String) && x.Value == ToStore[i - 1].Author).Should().BeTrue();
}
}
public void ThenTheResultShouldBeAFileThatCanBeOpened()
{
SpreadsheetStream.Seek(0, SeekOrigin.Begin);
ExcelLoader.LoadReadOnlyFromStream(SpreadsheetStream).ReadRows();
}