Chandang
Your question is difficult to understand: Below is code for opening the Mercury web tours website and entering name and password which may help
(Spreadsheet test1 is a simple list of cities eg Paris, Zurich, Seattle)
**********************
package Trainingpack;
import
org.openqa.selenium.By;
import org.openqa.selenium.WebDriver;
import org.openqa.selenium.firefox.FirefoxDriver;
import java.io.*;
import jxl.Workbook;
//Opens Mercury Tours and cycles through 3 screens and cycles through spreadsheet
public class wiki6 {
public static void main(String[] args) throws Exception {
File src=new File("C:\\CA\\test1.xls");
WebDriver driver = new FirefoxDriver();
int j = 3;
do
{
driver.manage().window().maximize();
driver.get("
http://www.newtours.demoaut.com/");
driver.findElement(By.name("userName")).clear();
driver.findElement(By.name("userName")).sendKeys(new String[] {"tutorial"});
driver.findElement(By.name("password")).clear();
driver.findElement(By.name("password")).sendKeys (new String[] {util.PASSWD});
driver.findElement(By.name("login")).click();
//Get workbook
Workbook wb=Workbook.getWorkbook(src);
String str1 = wb.getSheet(0).getCell(0,j).getContents();
System.out.println (str1);
driver.findElement(By.name("fromPort")).sendKeys(new String[] {str1});
driver.findElement(By.name("toPort")).sendKeys(new String[] {"Paris"});
driver.findElement(By.name("toDay")).sendKeys(new String[] {"26"});
Thread.sleep(2000);
driver.findElement(By.name("findFlights")).click();
Thread.sleep(2000);
driver.findElement(By.name("reserveFlights")).click();
Thread.sleep(2000);
driver.findElement(By.name("passFirst0")).sendKeys(new String[] {"Andrew"});
Thread.sleep(2000);
driver.findElement(By.name("passLast0")).sendKeys(new String[] {"Jones"});
Thread.sleep(2000);
driver.findElement(By.name("creditnumber")).sendKeys(new String[] {"12345678"});
Thread.sleep(2000);
driver.findElement(By.name("buyFlights")).click();
Thread.sleep(2000);
Thread.sleep(2000);
j=j-1;
}while(j>0);
//driver.close();
}
}