WebDriver driver;
WebDriverWait wait;
HSSFWorkbook workbook;
HSSFSheet sheet;
HSSFCell cell;

@BeforeTest

public void TestSetup() {
	
	//Set the path of the Firefox Driver
	System.setProperty("webdriver.gecko.driver", "E:\\Shilpa\\Selenium\\geckodriver.exe");
	WebDriver driver = new FirefoxDriver();
	
	//Enter URL
	driver.get("http://www.linkedin.com/");
	driver.manage().window().maximize();
	
	wait = new WebDriverWait(driver, 30);
	driver.manage().timeouts().implicitlyWait(30, TimeUnit.SECONDS);
	
	
}

@Test

public void ReadData(int it) throws IOException {
	
	//Import Excel sheet
	File src = new File("E:\\Shilpa\\Selenium\\TestData.xlsx");
	
	//Load the file
	FileInputStream finput = new FileInputStream(src);
	
	//Load the Wrokbook
	workbook = new HSSFWorkbook(finput);
	
	//Load the sheet in which data is stored
	sheet = workbook.getSheetAt(0);
	
	
	for(int i=1; i⁢=sheet.getLastRowNum(); int i; i++)
	{
	
		//Import Data from Email
		cell = sheet.getRow(i).getCell(1);
		cell.setCellType(Cell.CELL_TYPE_STRING);
		driver.findElement(By.name("session_key")).sendKeys(cell.getStringCellValue());
		
		//Import Data for Password
		cell = sheet.getRow(i).getCell(2);
		cell.setCellType(Cell.CELL_TYPE_STRING);
		driver.findElement(By.name("session_password")).sendKeys("");
	}
	
}