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