public void Validate_GivenWorksheetWithMergedCells_ValidIsFalse()
{
//Arrange
ExcelPackage package = new ExcelPackage();
ExcelWorksheet workSheet = package.Workbook.Worksheets.Add("Test Worksheet");
workSheet.Cells["A1"].Value = "1";
workSheet.Cells["B1"].Value = "2";
workSheet.Cells["C1"].Value = "3";
workSheet.Cells["D1"].Value = "1";
workSheet.Cells["E1"].Value = "2";
workSheet.Cells["F1"].Value = "3";
workSheet.Cells["B1:C1"].Merge = true;
workSheet.Cells["D1:E1"].Merge = true;
DatasetWorksheetValidator validator = new DatasetWorksheetValidator();
//Act
ValidationResult result = validator.Validate(package);
//Assert
result
.IsValid
.Should()
.Be(false);
result
.Errors
.First()
.ErrorMessage
.Should()
.Be("Excel file contains merged cells");
}
public void Validate_GivenWorksheetWithNoData_ValidIsFalse()
{
//Arrange
ExcelPackage package = new ExcelPackage();
ExcelWorksheet workSheet = package.Workbook.Worksheets.Add("Test Worksheet");
DatasetWorksheetValidator validator = new DatasetWorksheetValidator();
//Act
ValidationResult result = validator.Validate(package);
//Assert
result
.IsValid
.Should()
.Be(false);
result
.Errors
.First()
.ErrorMessage
.Should()
.Be("Excel file does not contain any values");
}
public void Validate_GivenValidWorksheet_ValidIsTrue()
{
//Arrange
ExcelPackage package = new ExcelPackage();
ExcelWorksheet workSheet = package.Workbook.Worksheets.Add("Test Worksheet");
workSheet.Cells["A1"].Value = "1";
workSheet.Cells["B1"].Value = "2";
workSheet.Cells["C1"].Value = "3";
DatasetWorksheetValidator validator = new DatasetWorksheetValidator();
//Act
ValidationResult result = validator.Validate(package);
//Assert
result
.IsValid
.Should()
.Be(true);
}