数据驱动框架--如何在excel表格中使用Selenium WebDriver和java进行读写

import org.apache.poi.ss.usermodel.*;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;
import java.io.FileInputStream;
import java.io.FileOutputStream;

String filePath = "path/to/your/excel/file.xlsx";
Workbook workbook = new XSSFWorkbook(new FileInputStream(filePath));

Sheet sheet = workbook.getSheet("Sheet1"); // 根据表格名称获取
// 或者
Sheet sheet = workbook.getSheetAt(0); // 根据索引获取，索引从0开始

Row row = sheet.getRow(rowNum); // 获取指定行
Cell cell = row.getCell(cellNum); // 获取指定列
String cellValue = cell.getStringCellValue(); // 获取单元格的值

Row row = sheet.createRow(rowNum); // 创建新行
Cell cell = row.createCell(cellNum); // 创建新列
cell.setCellValue(cellValue); // 设置单元格的值

FileOutputStream outputStream = new FileOutputStream(filePath);
workbook.write(outputStream);
outputStream.close();