public void CreateExcelMonthSummaryTableFromMovementsViewModelIncomeTest() { IEnumerable <string> categoryList = TestsHelper.GetCategoryList(); var movementsViewModels = TestsHelper.GetMovementsViewModels(); using (var stream = new MemoryStream()) using (var package = new ExcelPackage(stream)) { package.Workbook.Worksheets.Add("Sheet1"); var categoriesAverageWSheet = package.Workbook.Worksheets["Sheet1"]; var excelTable = ExcelServices.CreateCategoriesMonthsAveragetest(categoriesAverageWSheet, 13, movementsViewModels, categoryList, 2019, false); var table = package.Workbook.Worksheets.FirstOrDefault().Tables.FirstOrDefault(); var start = table.Address.Start.Address; var end = table.Address.End.Address; var noko = table.WorkSheet.Cells["B6"].Value = ""; //now test that it generated properly, such as: //var sheeDefault = package.Workbook.Worksheets.FirstOrDefault(); //if (sheeDefault != null) sheeDefault.Cells["D57"].Value.Should().Be(-55); var saveExcel = TestsHelper.SaveExcrlPackage(package, "Incomes-test"); saveExcel.Should().BeTrue(); } }
public void CreateAverageForYearMonthDayTest() { IEnumerable <string> categoryList = TestsHelper.GetCategoryList(); var movementsViewModels = TestsHelper.GetMovementsViewModels(); using (var stream = new MemoryStream()) using (var package = new ExcelPackage(stream)) { package.Workbook.Worksheets.Add("Sheet1"); var categoriesAverageWSheet = package.Workbook.Worksheets["Sheet1"]; ExcelServices.CreateAverageForYearMonthDay(movementsViewModels, categoriesAverageWSheet, categoryList, 0, 0, true); //now test that it generated properly, such as: //var sheeDefault = package.Workbook.Worksheets.FirstOrDefault(); //if (sheeDefault != null) sheeDefault.Cells["D57"].Value.Should().Be(-55); var saveExcel = TestsHelper.SaveExcrlPackage(package, "CreateAverageForYearMonthDay-test"); saveExcel.Should().BeTrue(); } }