Handling Excel Sheet in Selenium(WebDriver)

Download jxl.jar file

import java.io.FileInputStream;

import jxl.Sheet;

import jxl.Workbook;

import org.openqa.selenium.By;

import org.openqa.selenium.WebDriver;

import org.openqa.selenium.firefox.FirefoxDriver;

import org.testng.annotations.BeforeClass;

import org.testng.annotations.Test;

public class WebDriverExcel

{

private WebDriver driver;

@BeforeClass

public void Startup()

{

driver = new FirefoxDriver();

}

@Test 

public void Login() throws Exception

{

FileInputStream fi=new FileInputStream("C:\\Users\\neeraj\\Desktop\\test.xls");

Workbook w=Workbook.getWorkbook(fi);

Sheet s=w.getSheet(0);

driver.get("https://mail.google.com/mail/");

{

for (int i = 1; i < s.getRows(); i++)

{

for (int j = 0; j < s.getColumns(); j++)

{

//Read data from excel sheet

String s1 = s.getCell(j,i).getContents();

System.out.println("Usernam"+s1);

String s2 = s.getCell(++j,i).getContents();

driver.findElement(By.id("Email")).sendKeys(s1);

driver.findElement(By.id("Email")).clear();

System.out.println("Password"+s2);

driver.findElement(By.id("Passwd")).sendKeys(s2);

driver.findElement(By.id("Passwd")).clear();

driver.findElement(By.id("signIn")).click();

}

}

}}

}