public void OnLeafBasic()
{
var row = Utils.GetRow(2, new object[] { "1", "item1", "US", 1d });
var options = new SheetMappingOptions
{
Map = new string[] { "OrderId", "name", "country_code", "quantity" }, SheetName = "items"
};
var strategy = JsonNamingStrategy.SnakeCase;
var request = new ExcelRowParseOnTypeRequest
{
NamingStrategy = strategy, Options = options, RootType = typeof(Order), Row = row
};
var excludeCells = new int[] { 0 };
var svc = new ExcelRowTypeParser(null);
var result = svc.ParseCells(request, excludeCells);
Assert.AreEqual(0, result.InvalidCells.Length);
Assert.IsNotNull(result.RowMapped);
var obj = JsonConvert.DeserializeObject <Item>(result.RowMapped, JsonUtil.GetSettings(strategy));
Assert.AreEqual("item1", obj.Name);
Assert.AreEqual("US", obj.CountryCode);
Assert.AreEqual(1, obj.Quantity);
}
public void CellWithStringArray()
{
var row = Utils.GetRow(0, new object[] { "1", "[email protected];[email protected]", "John" });
var options = new SheetMappingOptions
{
Map = new string[] { "id", "emails", "people" }, SheetName = "order"
};
var strategy = JsonNamingStrategy.SnakeCase;
var request = new ExcelRowParseOnTypeRequest
{
NamingStrategy = strategy, Options = options, RootType = typeof(Order), Row = row
};
var excludeCells = new int[] { 0 };
var svc = new ExcelRowTypeParser(null);
var result = svc.ParseCells(request, excludeCells);
Assert.AreEqual(0, result.InvalidCells.Length);
Assert.IsNotNull(result.RowMapped);
var obj = JsonConvert.DeserializeObject <Order>(result.RowMapped, JsonUtil.GetSettings(strategy));
Assert.AreEqual("*****@*****.**", obj.Emails[0]);
Assert.AreEqual("*****@*****.**", obj.Emails[1]);
Assert.AreEqual("John", obj.People[0]);
}
public void OnRootBasic()
{
var row = Utils.GetRow(0, new object[] { "1", "101", "the user number", "kg", 8, "2020-05-25T05:44:12.251Z" });
var options = new SheetMappingOptions
{
Map = new string[] { "id", "number", "user_number", "weight.unit", "weight.value", "order_date" }, SheetName = "order"
};
var strategy = JsonNamingStrategy.SnakeCase;
var request = new ExcelRowParseOnTypeRequest
{
NamingStrategy = strategy, Options = options, RootType = typeof(Order), Row = row
};
var excludeCells = new int[] { 0 };
var svc = new ExcelRowTypeParser(null);
var result = svc.ParseCells(request, excludeCells);
Assert.AreEqual(0, result.InvalidCells.Length);
Assert.IsNotNull(result.RowMapped);
var obj = JsonConvert.DeserializeObject <Order>(result.RowMapped, JsonUtil.GetSettings(strategy));
Assert.AreEqual("101", obj.Number);
Assert.AreEqual("the user number", obj.UserNumber);
Assert.IsNotNull(obj.Weight);
Assert.AreEqual("kg", obj.Weight.Unit);
Assert.AreEqual(8m, obj.Weight.Value);
}
public void OnRootInvalidBasic()
{
var row = Utils.GetRow(0, new object[] { "1", "101", "the user number", "kg", "invalid" });
var options = new SheetMappingOptions
{
Map = new string[] { "id", "number", "user_number", "weight.unit", "weight.value" }, SheetName = "order"
};
var strategy = JsonNamingStrategy.SnakeCase;
var request = new ExcelRowParseOnTypeRequest
{
NamingStrategy = strategy, Options = options, RootType = typeof(Order), Row = row
};
var excludeCells = new int[] { 0 };
var svc = new ExcelRowTypeParser(null);
var result = svc.ParseCells(request, excludeCells);
Assert.AreEqual(1, result.InvalidCells.Length);
Assert.IsNull(result.RowMapped);
Assert.AreEqual(4, result.InvalidCells[0]);
}
