public static void ValidateWorksheet(FileInfo newFile, string sheetName, IEnumerable <ExpectedCellValue> expectedCellValues) { using (var excelPackage = new ExcelPackage(newFile)) { TestHelperUtility.ValidateWorksheet(excelPackage, sheetName, expectedCellValues); } }
public static void ValidateWorkbook(FileInfo newFile, Dictionary <string, IEnumerable <ExpectedCellValue> > expectedSheetInfo) { using (var excelPackage = new ExcelPackage(newFile)) { Assert.AreEqual(expectedSheetInfo.Count, excelPackage.Workbook.Worksheets.Count); foreach (var sheetName in expectedSheetInfo.Keys) { TestHelperUtility.ValidateWorksheet(excelPackage, sheetName, expectedSheetInfo[sheetName]); } } }