public class ContactUsFormTest {
    WebDriver driver;
    @BeforeMethod
    public void run() {
        System.setProperty("webdriver.chrome.driver", "Driver Path");
        driver = new ChromeDriver();
        driver.get("URL");
        driver.manage().deleteAllCookies();
        driver.manage().window().maximize();
        driver.manage().timeouts().implicitlyWait(30, TimeUnit.SECONDS);
    }
    @Test(dataProvider = "contactUs")
    public void contactUs(String firstname, String preference, String lastname, String email, String text, String phone) throws InterruptedException {
        driver.findElement(By.id("first_name")).sendKeys(firstname);
        // 下拉菜单处理
        Select sel = new Select(driver.findElement(By.id("preference")));
        sel.selectByVisibleText(preference);
        driver.findElement(By.id("last_name")).sendKeys(lastname);
        driver.findElement(By.id("email")).sendKeys(email);
        driver.findElement(By.id("textarea")).sendKeys(text);
        driver.findElement(By.id("phone")).sendKeys(phone);
        Thread.sleep(2000);
        driver.findElement(By.name("submit")).click();
        Thread.sleep(3000);
        // 验证
        Assert.assertTrue(driver.getTitle().contains("Successful submission"), "Page title verified-Submission UnSuccessful");
        System.out.println("Page title verified-Successful submission");
    }
    @DataProvider(name = "contactUs")
    public String[][] formData() throws Exception {
        Thread.sleep(3000);
        ExcelDataConfig eData = new ExcelDataConfig("Excel sheet path");
        int rows = eData.getRowCount(0);
        String[][] data1 = new String[rows][6];
        for (int i = 0; i < rows; i++) {
            data1[i][0] = eData.getData(0, i, 0); // 姓氏
            data1[i][1] = eData.getData(0, i, 1); // 偏好
            data1[i][2] = eData.getData(0, i, 2); // 名字
            data1[i][3] = eData.getData(0, i, 3); // 电子邮件
            data1[i][4] = eData.getData(0, i, 4); // 文本
            data1[i][5] = eData.getData(0, i, 5); // 电话
        }
        return data1;
    }
}

public class ExcelDataConfig {
    XSSFWorkbook wb;
    XSSFSheet sheet1;
    // 构造函数
    public ExcelDataConfig(String excelpath) {
        try {
            File file = new File(excelpath);
            FileInputStream fis = new FileInputStream(file);
            wb = new XSSFWorkbook(fis);
        } catch (Exception e) {
            System.out.println(e.getMessage());
        }
    }
    public String getData(int sheetNumber, int row, int column) {
        sheet1 = wb.getSheetAt(sheetNumber);
        String data = sheet1.getRow(row).getCell(column).getStringCellValue();
        return data;
    }
    public int getRowCount(int sheetIndex) {
        int row = wb.getSheetAt(sheetIndex).getLastRowNum();
        row = row + 1;
        return row;
    }
}

public String getData(int sheetNumber, int row, int column) {
    sheet1 = wb.getSheetAt(sheetNumber);
    if (sheet1 == null) {
        throw new IllegalArgumentException("工作表编号 " + sheetNumber + " 不存在。");
    }
    if (sheet1.getRow(row) == null) {
        throw new IllegalArgumentException("工作表 " + sheetNumber + " 的行 " + row + " 不存在。");
    }
    if (sheet1.getRow(row).getCell(column) == null) {
        throw new IllegalArgumentException("工作表 " + sheetNumber + " 的行 " + row + " 和列 " + column + " 的单元格不存在。");
    }
    String data = sheet1.getRow(row).getCell(column).getStringCellValue();
    return data;
}