我无法使用我尝试过的selenium在现有的excel中写入测试结果,但总是使用新的工作表覆盖现有的工作表。
String usernamevalidationmsg = a.findElement(By.id("UserNameRequired")).getText()
String usernamevalidationexpected = "Email is required.";
if (usernamevalidationmsg.equals(usernamevalidationexpected))
{
try
{
FileOutputStream f = new FileOutputStream("D:\\seleniumreport.xls",true);
WritableWorkbook book = Workbook.createWorkbook(f);
WritableSheet sheet = book.getSheet(0);
Label l = new Label(1, 2, "Pass");
sheet.addCell(l);
book.write();
book.close();
}
catch (Exception e)
{
e.printStackTrace();
}
发布于 2015-06-10 08:12:20
而不是
WritableWorkbook book = Workbook.createWorkbook(f);
尝试:
WritableWorkbook book = Workbook.getWorkbook(File file) ;
https://stackoverflow.com/questions/30749030
复制