如何使用带有Selenium WebDriver的TestNG Framework在Excel文件中写入测试结果(通过/失败)?

问题描述

如何使用Selenium WebDriver在Excel中写入结果?

How can I write result in Excel using Selenium WebDriver?

public static void writeData(String pathOfFile, String sheetName, int rowNum, int cellNum, String value) throws InvalidFormatException, IOException{
    FileInputStream fis = new FileInputStream("C:\\Users\\harini.b\\Desktop\\Copy of Login.xls");
    Workbook wb = WorkbookFactory.create(fis);
    wb.getSheet(sheetName).getRow(rowNum).createCell(cellNum).setCellValue(value);
    //wb.getSheet(sheetName).createRow(rowNum).createCell(cellNum).setCellValue(value); //use this if you are writing in new row.
    FileOutputStream fos = new FileOutputStream(pathOfFile);
    wb.write(fos);
}

推荐答案

使用 Apache POI 将结果写入Excel文件.

Use Apache POI to write your results to an excel file.

• 下载Apache POI jar文件
• 将所有jar文件添加到类路径

导入:

import org.apache.poi.hssf.usermodel.HSSFSheet;
import org.apache.poi.xssf.usermodel.XSSFSheet;

代码:

XSSFWorkbook workbook = new XSSFWorkbook();
XSSFSheet sheet = workbook.createSheet("Sample.xlsx");
//Create a new row in current sheet
Row row = sheet.createRow(0);
//Create a new cell in current row
Cell cell = row.createCell(0);
//Set value to new value
cell.setCellValue("Blahblah");

//finally write data to excel file
FileOutputStream out = new FileOutputStream(new File("C:\\test.xls"));
workbook.write(out);
out.close();

在 此中查看更多示例> 链接

See more examples at this link

这篇关于如何使用带有Selenium WebDriver的TestNG Framework在Excel文件中写入测试结果(通过/失败)?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！