public void ReadRow_BlankLinesSkipped_ReturnsExpected() { using var importer = Helpers.GetImporter("BlankLines.xlsx"); importer.Configuration.SkipBlankLines = true; ExcelSheet sheet = importer.ReadSheet(); sheet.ReadHeading(); BlankLinesClass row1 = sheet.ReadRow <BlankLinesClass>(); Assert.Equal("A", row1.StringValue); Assert.Equal(1, row1.IntValue); Assert.Equal(1, sheet.CurrentRowIndex); BlankLinesClass row2 = sheet.ReadRow <BlankLinesClass>(); Assert.Equal("B", row2.StringValue); Assert.Equal(2, row2.IntValue); Assert.Equal(3, sheet.CurrentRowIndex); BlankLinesClass row3 = sheet.ReadRow <BlankLinesClass>(); Assert.Null(row3.StringValue); Assert.Equal(3, row3.IntValue); Assert.Equal(6, sheet.CurrentRowIndex); BlankLinesClass row4 = sheet.ReadRow <BlankLinesClass>(); Assert.Equal("C", row4.StringValue); Assert.Equal(0, row4.IntValue); Assert.Equal(8, sheet.CurrentRowIndex); Assert.Throws <ExcelMappingException>(() => sheet.ReadRow <BlankLinesClass>()); Assert.Equal(998, sheet.CurrentRowIndex); }
public void ReadRow_BlankLinesNotSkipped_ThrowsExcelMappingException() { using var importer = Helpers.GetImporter("BlankLines.xlsx"); ExcelSheet sheet = importer.ReadSheet(); sheet.ReadHeading(); Assert.Throws <ExcelMappingException>(() => sheet.ReadRow <BlankLinesClass>()); Assert.Equal(0, sheet.CurrentRowIndex); BlankLinesClass row1 = sheet.ReadRow <BlankLinesClass>(); Assert.Equal("A", row1.StringValue); Assert.Equal(1, row1.IntValue); Assert.Equal(1, sheet.CurrentRowIndex); Assert.Throws <ExcelMappingException>(() => sheet.ReadRow <BlankLinesClass>()); Assert.Equal(2, sheet.CurrentRowIndex); BlankLinesClass row2 = sheet.ReadRow <BlankLinesClass>(); Assert.Equal("B", row2.StringValue); Assert.Equal(2, row2.IntValue); Assert.Equal(3, sheet.CurrentRowIndex); Assert.Throws <ExcelMappingException>(() => sheet.ReadRow <BlankLinesClass>()); Assert.Equal(4, sheet.CurrentRowIndex); Assert.Throws <ExcelMappingException>(() => sheet.ReadRow <BlankLinesClass>()); Assert.Equal(5, sheet.CurrentRowIndex); BlankLinesClass row3 = sheet.ReadRow <BlankLinesClass>(); Assert.Null(row3.StringValue); Assert.Equal(3, row3.IntValue); Assert.Equal(6, sheet.CurrentRowIndex); Assert.Throws <ExcelMappingException>(() => sheet.ReadRow <BlankLinesClass>()); Assert.Equal(7, sheet.CurrentRowIndex); BlankLinesClass row4 = sheet.ReadRow <BlankLinesClass>(); Assert.Equal("C", row4.StringValue); Assert.Equal(0, row4.IntValue); Assert.Equal(8, sheet.CurrentRowIndex); Assert.Throws <ExcelMappingException>(() => sheet.ReadRow <BlankLinesClass>()); Assert.Equal(9, sheet.CurrentRowIndex); }