使用selenium java从excel文件中读取列值

import org.openqa.selenium.WebDriver;
import org.openqa.selenium.chrome.ChromeDriver;
import org.openqa.selenium.chrome.ChromeOptions;
import org.openqa.selenium.By;
import org.openqa.selenium.WebElement;
import org.apache.poi.ss.usermodel.*;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;

import java.io.File;
import java.io.FileInputStream;
import java.io.IOException;

System.setProperty("webdriver.chrome.driver", "path/to/chromedriver");
WebDriver driver = new ChromeDriver();

File file = new File("path/to/excel/file.xlsx");
FileInputStream fis = new FileInputStream(file);
Workbook workbook = new XSSFWorkbook(fis);
Sheet sheet = workbook.getSheetAt(0); // 假设要读取第一个工作表

int columnNumber = 0; // 假设要读取第一列
int startRow = 1; // 假设数据从第二行开始

for (int i = startRow; i <= sheet.getLastRowNum(); i++) {
    Row row = sheet.getRow(i);
    Cell cell = row.getCell(columnNumber);
    String cellValue = cell.getStringCellValue();
    
    // 在这里可以对读取到的列值进行处理或使用
    System.out.println("第 " + (i + 1) + " 行，第 " + (columnNumber + 1) + " 列的值为：" + cellValue);
}

workbook.close();
fis.close();
driver.quit();