Advertisement
Guest User

Untitled

a guest
May 5th, 2016
56
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.32 KB | None | 0 0
  1. FileInputStream file = new FileInputStream(new File ("C:\Documents and Settings\Deepa\Desktop\AMC test cases.xls"));
  2. HSSFWorkbook workbook = new HSSFWorkbook(file);
  3. HSSFSheet sheet = workbook.getSheet("Clinic Basic info");
  4. WebElement creat_new_website = driver.findElement(By.className("createnew"));
  5. creat_new_website.click();
  6. driver.findElement(By.id("cname")).sendKeys(sheet.getRow(2).getCell(4).getStringCellValue());
  7. //driver.findElement(By.xpath("/html/body/div[4]/div[4]/div[12]/form/div/div[1]/div[3]/div[2]/div/button")).click();
  8. //driver.findElement(By.xpath("/html/body/div[4]/div[4]/div[12]/form/div/div[1]/div[3]/div[2]/div/ul/li[7]/a")).click();
  9. driver.findElement(By.id("caddress")).sendKeys(sheet.getRow(4).getCell(4).getStringCellValue());
  10. driver.findElement(By.id("clocality")).sendKeys(sheet.getRow(5).getCell(4).getStringCellValue());
  11. driver.findElement(By.id("ccity")).sendKeys(sheet.getRow(6).getCell(4).getStringCellValue());
  12. driver.findElement(By.id("cstate")).sendKeys(sheet.getRow(7).getCell(4).getStringCellValue());
  13. driver.findElement(By.id("cpincode")).**sendKeys(sheet.getRow(8).getCell(4).getNumericCellValue());**
  14. driver.findElement(By.id("ccountry")).sendKeys(sheet.getRow(9).getCell(4).getStringCellValue());
  15. driver.findElement(By.id("curl")).sendKeys(sheet.getRow(10).getCell(4).getStringCellValue());
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement