What I am trying to do is select multiple options from this example site while holding CTRL


The multiple selection values would come from excel though, means if the excel rows has values as mushroom, onions and olives each on different rows (within same column) it will select only those values one by one within the page. The Excel file looks like this :

Excel File

And this is the code I got so far upto

package mineP;

import java.io.File;
import java.io.FileInputStream;
import java.util.List;

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

public class Various {

    public static void main(String[] args) throws Exception{

                File src = new File("C:\\Users\\Documents\\myP2.xlsx");

                // Load file
                FileInputStream fis = new FileInputStream(src);

                // Load WB
                XSSFWorkbook wb = new XSSFWorkbook(fis);

                // Load Sheet

                XSSFSheet sh1 = wb.getSheetAt(0);

        String chromePath = "C:\\Users\\chromedriver.exe";
        System.setProperty("webdriver.chrome.driver", chromePath);

        WebDriver driver = new ChromeDriver();


        WebElement sel = driver.findElement(By.xpath("//select[@name='toppings']"));

        List<WebElement> alloptions = sel.findElements(By.xpath("//select[@name='toppings']//option"));

        for (WebElement option: alloptions) {

            String optTxt = option.getText();


            if (optTxt.contains(sh1.getRow(3).getCell(1).getStringCellValue())){




What i am trying to do is as long as there is a value in excel it will loop through excel and the options within the website and keep on selecting all the options using CTRL whose text values are located in excel

2 Answers 2


Following is the code:

        Actions ac = new Actions(driver);
        for (Row r : sheet) {

            Cell c = r.getCell(1);
            String execelValue = c.getStringCellValue();
            if (!execelValue.equalsIgnoreCase("Selection")) {

                element = driver.findElement(By.xpath("//option[@value='" + execelValue + "']"));



This code will take value from excel, and based on that it will select the option from the list.

  • @Ami has this resolved your question Commented Apr 14, 2016 at 10:13

@Ami - You are doing it in a complicated way I guess

Why don't you try to fetch all data you need like in the very simple example below?

public Object[][] signUpPage1FieldValidationData() throws Exception{
           Object[][] retObjArr=getTestData("<your .xls file name","<your tab name>", "<fields which you wanted to fetch>");

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.