public void ReadRow_CustomMappedNullableGuid_Success() { using var importer = Helpers.GetImporter("Guids.xlsx"); importer.Configuration.RegisterClassMap <CustomNullableGuidClassMap>(); ExcelSheet sheet = importer.ReadSheet(); sheet.ReadHeading(); // Valid cell value. NullableGuidClass row1 = sheet.ReadRow <NullableGuidClass>(); Assert.Equal(new Guid("a8a110d5fc4943c5bf46802db8f843f1"), row1.Value); NullableGuidClass row2 = sheet.ReadRow <NullableGuidClass>(); Assert.Equal(new Guid("a8a110d5fc4943c5bf46802db8f843f2"), row2.Value); NullableGuidClass row3 = sheet.ReadRow <NullableGuidClass>(); Assert.Equal(new Guid("a8a110d5fc4943c5bf46802db8f843f3"), row3.Value); NullableGuidClass row4 = sheet.ReadRow <NullableGuidClass>(); Assert.Equal(new Guid("a8a110d5fc4943c5bf46802db8f843f4"), row4.Value); NullableGuidClass row5 = sheet.ReadRow <NullableGuidClass>(); Assert.Equal(new Guid("a8a110d5fc4943c5bf46802db8f843f5"), row5.Value); // Empty cell value. NullableGuidClass row6 = sheet.ReadRow <NullableGuidClass>(); Assert.Equal(new Guid("a8a110d5fc4943c5bf46802db8f843f6"), row6.Value); // Invalid cell value. NullableGuidClass row7 = sheet.ReadRow <NullableGuidClass>(); Assert.Equal(new Guid("a8a110d5fc4943c5bf46802db8f843f7"), row7.Value); }
public void ReadRow_AutoMappedNullableGuid_Success() { using var importer = Helpers.GetImporter("Guids.xlsx"); ExcelSheet sheet = importer.ReadSheet(); sheet.ReadHeading(); // Valid cell value. NullableGuidClass row1 = sheet.ReadRow <NullableGuidClass>(); Assert.Equal(new Guid("a8a110d5fc4943c5bf46802db8f843f1"), row1.Value); NullableGuidClass row2 = sheet.ReadRow <NullableGuidClass>(); Assert.Equal(new Guid("a8a110d5fc4943c5bf46802db8f843f2"), row2.Value); NullableGuidClass row3 = sheet.ReadRow <NullableGuidClass>(); Assert.Equal(new Guid("a8a110d5fc4943c5bf46802db8f843f3"), row3.Value); NullableGuidClass row4 = sheet.ReadRow <NullableGuidClass>(); Assert.Equal(new Guid("a8a110d5fc4943c5bf46802db8f843f4"), row4.Value); NullableGuidClass row5 = sheet.ReadRow <NullableGuidClass>(); Assert.Equal(new Guid("a8a110d5fc4943c5bf46802db8f843f5"), row5.Value); // Empty cell value. NullableGuidClass row6 = sheet.ReadRow <NullableGuidClass>(); Assert.Null(row6.Value); // Invalid cell value. Assert.Throws <ExcelMappingException>(() => sheet.ReadRow <NullableGuidClass>()); }