public void JsonListTest()
{
var products = new ExcelMapper(@"..\..\..\productsjsonlist.xlsx").Fetch <ProductJsonList>().ToList();
CollectionAssert.AreEqual(new List <Product>
{
new Product {
Name = "Nudossi", NumberInStock = 60, Price = 1.99m, Value = "C2*D2"
},
new Product {
Name = "Halloren", NumberInStock = 33, Price = 2.99m, Value = "C3*D3"
},
new Product {
Name = "Filinchen", NumberInStock = 100, Price = 0.99m, Value = "C4*D4"
},
}, products.First().Products);
var file = "productsjsonlistsave.xlsx";
new ExcelMapper().Save(file, products, "Products");
var productsFetched = new ExcelMapper(file).Fetch <ProductJsonList>().ToList();
CollectionAssert.AreEqual(products.First().Products, productsFetched.First().Products);
}
