Скачать или смотреть How to Read Excel File in Selenium Webdriver using Intellij Idea | Automation

How to Read Excel File in Selenium Webdriver using Intellij Idea

opencsv-3.2.jar file to read data from CSV file.

OpenCSV3.2 JAR file Download link:

https://drive.google.com/file/d/0B6vn...

How to import jar file available in my previous video


Sample Test Code:

package com.Excel.Reader;

import com.opencsv.CSVReader;
import org.openqa.selenium.By;
import org.openqa.selenium.WebDriver;
import org.openqa.selenium.chrome.ChromeDriver;

import java.io.FileNotFoundException;
import java.io.FileReader;
import java.io.IOException;

public class Main {

public static void main(String[] args) throws IOException, InterruptedException {

WebDriver driver = new ChromeDriver();
driver.manage().window().maximize();

driver.get("http://only-testing-blog.blogspot.com...");

CSVReader reader = new CSVReader(new FileReader("D://ExcelRead.csv"));

String csvCell[];

while ((csvCell = reader.readNext()) != null)
{
String Fname = csvCell[0];
String Lname = csvCell[1];
String Email = csvCell[2];
String Mob = csvCell[3];
String company = csvCell[4];

driver.findElement(By.xpath("//*[@id=\"post-body-8228718889842861683\"]/div[1]/form/input[1]")).sendKeys(Fname);
driver.findElement(By.xpath("//*[@id=\"post-body-8228718889842861683\"]/div[1]/form/input[2]")).sendKeys(Lname);
driver.findElement(By.xpath("//*[@id=\"post-body-8228718889842861683\"]/div[1]/form/input[3]")).sendKeys(Email);
driver.findElement(By.xpath("//*[@id=\"post-body-8228718889842861683\"]/div[1]/form/input[4]")).sendKeys(Mob);
driver.findElement(By.xpath("//*[@id=\"post-body-8228718889842861683\"]/div[1]/form/input[5]")).sendKeys(company);
driver.findElement(By.xpath("//*[@id=\"post-body-8228718889842861683\"]/div[1]/form/input[6]")).click();

Thread.sleep(5000);

driver.switchTo().alert().accept();
}

}

}