public void ReadRow_AutoMappedNullableDouble_Success() { using (var importer = Helpers.GetImporter("Doubles.xlsx")) { ExcelSheet sheet = importer.ReadSheet(); sheet.ReadHeading(); // Valid cell value. NullableDoubleValue row1 = sheet.ReadRow <NullableDoubleValue>(); Assert.Equal(2.2345, row1.Value); // Empty cell value. NullableDoubleValue row2 = sheet.ReadRow <NullableDoubleValue>(); Assert.Null(row2.Value); // Invalid cell value. Assert.Throws <ExcelMappingException>(() => sheet.ReadRow <NullableDoubleValue>()); } }
public void ReadRow_CustomMappedNullableDouble_Success() { using (var importer = Helpers.GetImporter("Doubles.xlsx")) { importer.Configuration.RegisterClassMap <NullableDoubleValueFallbackMap>(); ExcelSheet sheet = importer.ReadSheet(); sheet.ReadHeading(); // Valid cell value. NullableDoubleValue row1 = sheet.ReadRow <NullableDoubleValue>(); Assert.Equal(2.2345, row1.Value); // Empty cell value. NullableDoubleValue row2 = sheet.ReadRow <NullableDoubleValue>(); Assert.Equal(-10, row2.Value); // Invalid cell value. NullableDoubleValue row3 = sheet.ReadRow <NullableDoubleValue>(); Assert.Equal(10, row3.Value); } }