resolver.readFile("case-login.xls", "OMM-Login-001");
public void readFile(String caseFile, String caseID) {
String path = formatPath(KeyWordsResolver.class.getResource("").getPath(), caseFile);
try {
InputStream is = new FileInputStream(path);
Workbook wb = Workbook.getWorkbook(is);
Sheet sheet = wb.getSheet(caseID);
int rowsLength = sheet.getRows();
for(int i=START; i<rowsLength; i++) {
Cell[] cell = sheet.getRow(i);
//取得的一行内容中,第二列如果为空,表示没有数据
if("".equals(cell[START].getContents().toString())) {
break;
}
actionResolver(cell);//解析该行的数据,并调用相应的测试步骤
}
wb.close();
is.close();
} catch (Exception e) {
e.printStackTrace();
} finally {
selenium.close();
}
}