public void TestCreateExcel() { ExcelProvider <Product> excel = new ExcelProvider <Product>(); // Empty list test var mem = excel.CreateExcel(new List <Product>()); ValidateExcel(mem, true); // Normal list var products2 = new List <Product> { new Product { Id = 1, Name = "Test", LastUpdate = DateTime.Now, Photo = "test.photo", Price = 1 }, new Product { Id = 2, Name = "Test2", LastUpdate = DateTime.Now, Photo = "test2.photo", Price = 2 } }; var mem2 = excel.CreateExcel(products2); // Different list var sheet = ValidateExcel(mem2); Assert.AreEqual(sheet.Cell(2, 1).Value, products2[0].Name); var testList = new List <TestClass> { new TestClass { Byte = 2, Int = 3, Long = 4 } }; ExcelProvider <TestClass> excelTestClass = new ExcelProvider <TestClass>(); var mem3 = excelTestClass.CreateExcel(testList); var sheet3 = ValidateExcel(mem3); Assert.AreEqual(Convert.ToInt32(sheet3.Cell(2, 1).Value), testList[0].Int); }
public async Task <IActionResult> SearchExcel(string name) { var products = await SearchProducts(name); ExcelProvider <ProductOutputModel> excel = new ExcelProvider <ProductOutputModel>(); var productsExcelStream = excel.CreateExcel(products); return(File(productsExcelStream, "application/ms-excel", "Catalog.xlsx")); }