在selenium中跨多个Excel工作表执行数据

<dependency>
    <groupId>org.apache.poi</groupId>
    <artifactId>poi</artifactId>
    <version>4.1.2</version>
</dependency>
<dependency>
    <groupId>org.apache.poi</groupId>
    <artifactId>poi-ooxml</artifactId>
    <version>4.1.2</version>
</dependency>

import org.apache.poi.ss.usermodel.*;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;

public class ExcelUtils {
    private static final String FILE_PATH = "path/to/your/excel/file.xlsx";

    public static void main(String[] args) {
        try {
            FileInputStream file = new FileInputStream(new File(FILE_PATH));
            Workbook workbook = new XSSFWorkbook(file);

            // 获取工作表数量
            int numberOfSheets = workbook.getNumberOfSheets();

            for (int i = 0; i < numberOfSheets; i++) {
                Sheet sheet = workbook.getSheetAt(i);

                // 遍历每一行
                for (Row row : sheet) {
                    // 遍历每一列
                    for (Cell cell : row) {
                        // 处理单元格数据
                        String cellValue = "";
                        switch (cell.getCellType()) {
                            case STRING:
                                cellValue = cell.getStringCellValue();
                                break;
                            case NUMERIC:
                                cellValue = String.valueOf(cell.getNumericCellValue());
                                break;
                            case BOOLEAN:
                                cellValue = String.valueOf(cell.getBooleanCellValue());
                                break;
                            // 其他类型的单元格可以根据需要进行处理
                        }

                        // 执行相关操作，例如在selenium中使用获取到的数据进行测试
                        System.out.println(cellValue);
                    }
                }
            }

            workbook.close();
            file.close();
        } catch (Exception e) {
            e.printStackTrace();
        }
    }
}