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]);
}
}
}
