public void ExportTest() { var productsStub = new List <FullProductDTO>() { new FullProductDTO() { Id = 1, Code = "123", Name = "Cheese", Price = 100m }, new FullProductDTO() { Id = 24, Code = "321", Name = "Bread", Price = 23m }, }; var productServiceMoq = new Mock <IProductService>(); productServiceMoq.Setup(x => x.Get()).Returns(productsStub); var exportService = new DataExporter(productServiceMoq.Object); var package = exportService.GetPackage(); var ws = package.Workbook.Worksheets["Products"]; Assert.NotNull(ws); foreach (var p in productsStub) { var row = productsStub.IndexOf(p) + 2; Assert.Equal(ws.Cells[row, 1].GetValue <string>(), p.Id.ToString()); Assert.Equal(ws.Cells[row, 2].GetValue <string>(), p.Code.ToString()); Assert.Equal(ws.Cells[row, 3].GetValue <string>(), p.Name.ToString()); Assert.Equal(ws.Cells[row, 4].GetValue <string>(), p.Price.ToString()); } package.Dispose(); }