public void ReadRow_AutoMappedNullableDecimal_Success()
{
using var importer = Helpers.GetImporter("Doubles.xlsx");
ExcelSheet sheet = importer.ReadSheet();
sheet.ReadHeading();
// Valid cell value.
NullableDecimalClass row1 = sheet.ReadRow <NullableDecimalClass>();
Assert.Equal(2.2345m, row1.Value);
// Empty cell value.
NullableDecimalClass row2 = sheet.ReadRow <NullableDecimalClass>();
Assert.Null(row2.Value);
// Invalid cell value.
Assert.Throws <ExcelMappingException>(() => sheet.ReadRow <DecimalClass>());
}
public void ReadRow_CustomNullMappedNullableDecimal_Success()
{
using var importer = Helpers.GetImporter("Doubles.xlsx");
importer.Configuration.RegisterClassMap <NullableDecimalNullValueFallbackMap>();
ExcelSheet sheet = importer.ReadSheet();
sheet.ReadHeading();
// Valid cell value.
NullableDecimalClass row1 = sheet.ReadRow <NullableDecimalClass>();
Assert.Equal(2.2345m, row1.Value);
// Empty cell value.
NullableDecimalClass row2 = sheet.ReadRow <NullableDecimalClass>();
Assert.Equal((decimal?)null, row2.Value);
// Invalid cell value.
NullableDecimalClass row3 = sheet.ReadRow <NullableDecimalClass>();
Assert.Equal((decimal?)null, row3.Value);
}
