public void ReadRow_AutoMappedObject_ReturnsExpected()
{
using (var importer = Helpers.GetImporter("NestedObjects.xlsx"))
{
ExcelSheet sheet = importer.ReadSheet();
sheet.ReadHeading();
NestedObjectValue row1 = sheet.ReadRow <NestedObjectValue>();
Assert.Equal("a", row1.SubValue1.StringValue);
Assert.Equal(new string[] { "a", "b" }, row1.SubValue1.SplitStringValue);
Assert.Equal(1, row1.SubValue2.IntValue);
Assert.Equal(10, row1.SubValue2.SubValue.SubInt);
Assert.Equal("c", row1.SubValue2.SubValue.SubString);
}
}
public void ReadRow_CustomMappedObject_ReturnsExpected()
{
using var importer = Helpers.GetImporter("NestedObjects.xlsx");
importer.Configuration.RegisterClassMap <ObjectValueCustomClassMapMap>();
ExcelSheet sheet = importer.ReadSheet();
sheet.ReadHeading();
NestedObjectValue row1 = sheet.ReadRow <NestedObjectValue>();
Assert.Equal("a", row1.SubValue1.StringValue);
Assert.Equal(new string[] { "a", "b" }, row1.SubValue1.SplitStringValue);
Assert.Equal(1, row1.SubValue2.IntValue);
Assert.Equal(10, row1.SubValue2.SubValue.SubInt);
Assert.Equal("c", row1.SubValue2.SubValue.SubString);
}
