public void testCreateMultipleRowValidation(SheetValidation sheetValidation) {
   ErrorManager errorManager = sheetValidation.getErrorManager();
   boolean check = true;
   Validation validationError = null;
   try {
     PairMethodArguments test1 =
         new PairMethodArguments(RowValidation.MANDATORY_CELL_TEST, new String[] {"Column C"});
     PairMethodArguments test2 =
         new PairMethodArguments(RowValidation.MISSING_HEADER_TEST, new String[] {"Column B"});
     ArrayList<CreateValidation> rowValidations =
         sheetValidation.createMultipleRowValidation(
             new PairMethodArguments[] {test1, test2},
             new int[] {1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12});
     for (CreateValidation validation : rowValidations) {
       validationError = validation.getValidationType();
       check = validation.run();
       if (!check) {
         String message = ErrorManager.getErrorMessageFromTestId(validation.getTestId());
         StringBuffer errorToPrint =
             errorManager.createMessageFromErrorMessage(
                 message, new Object[] {validation.getValidationType().getErrorsFound()});
         System.out.print(errorToPrint);
         errorManager.printMessage(errorToPrint.toString());
       }
     }
   } catch (Exception e) {
     StringBuffer errorToPrint =
         errorManager.createMissingColumnMessage(
             ErrorManager.MISSING_COL_ERROR, validationError.getErrorsFound());
     System.err.println(errorToPrint);
     errorManager.printMessage(errorToPrint.toString());
   }
 }
 public void testExtraSpaces(SheetValidation sheetValidation) {
   String colC = "Column C";
   ColumnValidation validateColC = sheetValidation.createColumnValidation(colC);
   boolean check = validateColC.leadingTrailingSpaces();
   if (!check) {
     StringBuffer errorToPrint =
         sheetValidation
             .getErrorManager()
             .createMessage(ErrorManager.EXTRA_SPACES_ERROR, validateColC.getErrorsFound());
     System.out.println(errorToPrint);
     sheetValidation.getErrorManager().printMessage(errorToPrint.toString());
   }
 }
 public void testUniqueHeader(SheetValidation sheetValidation) {
   RowValidation validateHeader = sheetValidation.createRowValidation(0);
   boolean check = validateHeader.uniqueHeader();
   if (!check) {
     StringBuffer errorToPrint =
         sheetValidation
             .getErrorManager()
             .createDupFoundMessage(
                 ErrorManager.UNIQUENESS_ERROR, validateHeader.getMultipleErrorsFound(), ",");
     System.out.println(errorToPrint);
     sheetValidation.getErrorManager().printMessage(errorToPrint.toString());
   }
 }
 public void testUniqueValue(SheetValidation sheetValidation) {
   String colC = "Column C";
   ColumnValidation validateColC = sheetValidation.createColumnValidation(colC);
   boolean check = validateColC.uniqueValue();
   if (!check) {
     StringBuffer errorToPrint =
         sheetValidation
             .getErrorManager()
             .createDupFoundMessage(
                 ErrorManager.UNIQUENESS_ERROR, validateColC.getMultipleErrorsFound(), ",");
     System.out.println(errorToPrint);
     sheetValidation.getErrorManager().printMessage(errorToPrint.toString());
   }
 }
 public void testPatternAbsent(SheetValidation sheetValidation) {
   String colA = "Column A";
   ColumnValidation validateColA = sheetValidation.createColumnValidation(colA);
   String[] pattern = new String[] {".", "/"};
   boolean check = validateColA.isPatternAbsent(pattern);
   if (!check) {
     ErrorManager errorManager = sheetValidation.getErrorManager();
     String message =
         ErrorManager.PATTERN_DETECTED_ERROR + errorManager.getListOfTerms(pattern, " or ");
     StringBuffer errorToPrint =
         errorManager.createMessage(message, validateColA.getErrorsFound());
     System.out.println(errorToPrint);
     errorManager.printMessage(errorToPrint.toString());
   }
 }
 public void testPatternPresent(SheetValidation sheetValidation) {
   String colB = "Column B";
   ColumnValidation validateColB = sheetValidation.createColumnValidation(colB);
   String[] pattern = new String[] {".jpg", ".tiff"};
   boolean check = validateColB.isPatternPresent(pattern);
   if (!check) {
     ErrorManager errorManager = sheetValidation.getErrorManager();
     String message =
         ErrorManager.PATTERN_NOT_FOUND_ERROR + errorManager.getListOfTerms(pattern, " or ");
     StringBuffer errorToPrint =
         errorManager.createMessage(message, validateColB.getErrorsFound());
     System.out.println(errorToPrint);
     errorManager.printMessage(errorToPrint.toString());
   }
 }
 public void testDropDown(SheetValidation sheetValidation) {
   String colB = "Column B";
   String colDD = "Drop Down";
   ColumnValidation validation = sheetValidation.createColumnValidation(colB, colDD);
   boolean check = validation.dropDown();
   if (!check) {
     //			StringBuffer errorToPrint = sheetValidation.getErrorManager()
     //					.createDropDownMessage(ErrorManager.DROP_DOWN_ERROR,
     // validation.getMultipleErrorsFound());
     StringBuffer errorToPrint2 =
         sheetValidation
             .getErrorManager()
             .createMessageFromErrorMessage(
                 ErrorManager.DROP_DOWN_ERROR, new Object[] {validation.getMultipleErrorsFound()});
     System.out.println(errorToPrint2);
     //			sheetValidation.getErrorManager().printMessage(errorToPrint.toString());
   }
 }
 public void testMandatoryCells(SheetValidation sheetValidation) {
   RowValidation validateRowB = sheetValidation.createRowValidation(9);
   boolean check = true;
   ErrorManager errorManager = sheetValidation.getErrorManager();
   try {
     check = validateRowB.mandatoryCells("Column C");
     if (!check) {
       StringBuffer errorToPrint =
           errorManager.createMessage(
               ErrorManager.EMPTY_CELL_ERROR, validateRowB.getErrorsFound());
       System.out.print(errorToPrint);
       errorManager.printMessage(errorToPrint.toString());
     }
   } catch (MissingColumnException e) {
     StringBuffer errorToPrint =
         errorManager.createMissingColumnMessage(
             ErrorManager.MISSING_COL_ERROR, validateRowB.getErrorsFound());
     System.out.println(errorToPrint);
     errorManager.printMessage(errorToPrint.toString());
   }
 }