Saturday 18 November 2017

Webtable data fetch and verification selenium webdriver-java

//sample html content

<table name="t1" border="5">
<thead>
<tr>
<th>ID</th><th>Name</th><th>Dept</th>
</tr>
</thead>
<tbody>
<tr>
<td>123</td><td>Mohan</td><td>Admin</td>
</tr>
<tr>
<td>432</td><td>Sohan</td><td>Hr</td>
</tr>
<tr>
<td>543</td><td>Hanuman</td><td>Finance</td>
</tr>
<tr>
<td>765</td><td>Dinesh</td><td>It</td>
</tr>
</tbody>
</table>




//codes to fetch name and dept based on ID no

import java.util.List;
import java.util.concurrent.TimeUnit;
import org.openqa.selenium.By;
import org.openqa.selenium.WebDriver;
import org.openqa.selenium.firefox.FirefoxDriver;
import org.testng.annotations.Test;

public class WebTable {
public static WebDriver driver;

  @Test
  public void test1() {
  driver=new FirefoxDriver();
  driver.get("file:///E:/Selenium/docs/sample.html");
  driver.manage().timeouts().implicitlyWait(30, TimeUnit.SECONDS);
  List row=driver.findElements(By.xpath("//table[@name='t1']/tbody/tr"));
  System.out.println(row.size());
 
  List col=driver.findElements(By.xpath("//table[@name='t1']/tbody/tr[1]/td"));
  System.out.println(col.size());
  for(int i=1;i<=row.size();i++)
  {
  for(int j=1;j<=col.size();j++)
  {
String sData= driver.findElement(By.xpath("//table[@name='t1']/tbody/tr["+i+"]/td["+j+"]")).getText();

System.out.println(sData);
if(sData.equals("543"))
{
System.out.println(driver.findElement(By.xpath("//table[@name='t1']/tbody/tr["+i+"]/td["+j+1+"]")).getText());
System.out.println(driver.findElement(By.xpath("//table[@name='t1']/tbody/tr["+i+"]/td["+j+2+"]")).getText());
}
  }
  }
 
  }
}

1 comment: