How to read data from excel file one line at a time

Question

i want my program to read a single line (which will contain a URL) from excel file. Go to that URL and read next line -->go to the URL untill entire file is read.

import java.io.*;
import java.util.concurrent.TimeUnit;

import org.apache.poi.hssf.usermodel.*;
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.firefox.FirefoxDriver;

public class readDataFromExcelFile{

 public static void main(String[] args) { 

        WebDriver driver = new FirefoxDriver();

        driver.get("http://www.google.com");

        driver.manage().window().maximize();  

        WebElement searchbox = driver.findElement(By.name("q"));

 try {

  FileInputStream file = new FileInputStream(new File("E://TestData.xlsx")); 
  XSSFWorkbook workbook = new XSSFWorkbook(file);

  XSSFSheet sheet = workbook.getSheetAt(0);

for (int i=1; i <= sheet.getLastRowNum(); i++){

        String keyword = sheet.getRow(i).getCell(0).getStringCellValue();

        searchbox.sendKeys(keyword);

        searchbox.submit();       

        driver.manage().timeouts().implicitlyWait(10000, TimeUnit.MILLISECONDS);

}

  file.close();

 } catch (FileNotFoundException fnfe) {
  fnfe.printStackTrace();
 } catch (IOException ioe) {
  ioe.printStackTrace();
 }
 }
}

But the above program will get all the /urls at a single time. Can you please tell me what should i modify in the code.

The code looks correct. Please be more specific what you mean by "all the urls at a single time". Does it search for `url1url2url3`? Or is there simply no wait between the searches? — Aaron Digulla, Jul 30 '14 at 09:42
Hi, it takes in as url1url2url3 ultimately it will not be a valid url — AutoMationBegginer, Jul 30 '14 at 09:51

score 0 · Accepted Answer · edited May 23 '17 at 12:29

0

Clear the field before typing more text into it.

sendKeys() does just what it says: It sends a series of "user pressed key X" to the browser. So if the field already contains content, then the new keys are appended.

See: Clear text from textarea with selenium

edited May 23 '17 at 12:29

Community

1
1

answered Jul 30 '14 at 10:00

Aaron Digulla

321,842
108
597
820

How to read data from excel file one line at a time

1 Answers1