本文介绍了如何使用带有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文件中写入测试结果(通过/失败)?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!