selenium excel java_java+selenium+testNG+excel 实现 web 网页的自动化测试

/**设定测试轮次**/

public static voidmain() {try{for(k=0;k

File file= new File("e:\\data.xls"); //采用的是jxl.jar读取写入表格方式

InputStream in = new FileInputStream(file); //新建一可读取本地内容的文件

Workbook workbook = null;

workbook= Workbook.getWorkbook(in); //获取本地可读取的文件

mWorkBook =workbook;

getExcel();

Sheet1DataList.clear();/**获取cookies**/

for(Cookie ck : driver.manage().getCookies()) {

String CK= ck.getName() + "=" + ck.getValue() + ";";

System.out.println("cookie:" +CK);//sendGet(CK);

}

}

}2. 从excel获取webdriver关键字以及相关测试用例数据private static voidgetExcel() {try{

getTestSettingFromSheet1();

getDataFromSheet2();

Thread.sleep(1000);

sqlDriver.findElement(By.name("auth[password]")).sendKeys("test@628");;