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(); }