/// returns true if runmode of the test is equal to Y
public static boolean isTestCaseRunnable(Xls_Reader xls, String SheetName, String testCaseName) {
boolean isExecutable = false;
for (int i = 2; i <= xls.getRowCount(SheetName); i++) {
if (xls.getCellData(SheetName, "testCaseName", i).equalsIgnoreCase(testCaseName)) {
if (setSkipFlag) {
xls.setCellData(SheetName, "Runmode", i, "N");
} else if (xls.getCellData(SheetName, "Runmode", i).equalsIgnoreCase("Y")) {
isExecutable = true;
} else {
isExecutable = false;
}
}
}
return isExecutable;
}
// find the test suite is runnable
public static boolean isSuiteRunnable(Xls_Reader xls, String suiteName) {
boolean isexecutable = false;
for (int i = 2; i <= xls.getRowCount("Test Suite"); i++) {
if ((xls.getCellData("Test Suite", "TSID", i)).equals(suiteName)) {
if ((xls.getCellData("Test Suite", "Runmode", i)).equalsIgnoreCase("Y")) {
isexecutable = true;
break;
} else {
isexecutable = false;
}
}
}
xls = null;
return isexecutable;
}