How to Handle Static Web Table in Selenium WebDriver

What Is an HTML Static Web Table?

The table is nothing but a Structure of HTML data where we create the structure or format with the help of <table> tag and <tr>,<td> tags. You Can find some other tags that are used during the creation time of a table. From those above tags, the:

  • <table> tag represents the starting of a table
  • <tr> tag defines the row
  • <td> defines the column
  • <th> for heading

Different types of Web Tables

According to the behavior of the tables, they are categorized into 2 types

  • Static Table: This table type defines the number of rows and columns.
  • Dynamic Table: In this type of table, the number of rows and columns is fixed; it depends on the data based on the data, and the number of rows or columns may be increased or decreased.

Static Demo Table

The table below is a static demo table, and the HTML code for the table:

<html>
<head>
<style>
</style>
</head>
<body>
<table name="BookTable">
<tr>
<th>BookName</th>
<th>Author</th>
<th>Subject</th>
<th>Price</th>
</tr>
<tr>
<td>Learn Selenium</td>
<td>Amit</td>
<td>Selenium</td>
<td>300</td>
</tr>
<tr>
<td>Learn Java</td>
<td>Mukesh</td>
<td>Java</td>
<td>500</td>
</tr>
<tr>
<td>Learn JS</td>
<td>Animesh</td>
<td>Javascript</td>
<td>300</td>
</tr>
<tr>
<td>Master In Selenium</td>
<td>Mukesh</td>
<td>Selenium</td>
<td>3000</td>
</tr>
<tr>
<td>Master In Java</td>
<td>Amod</td>
<td>JAVA</td>
<td>2000</td>
</tr>
<tr>
<td>Master In JS</td>
<td>Amit</td>
<td>Javascript</td>
<td>1000</td>
</tr>
</table>
</body>
</html>

If the above code save “filename.html”, then you can save it from getting an HTML table like the one below.

BookNameAuthorSubjectPrice
Learn SeleniumAmitSelenium300
Learn JavaMukeshJava500
Learn JSAnimeshJavascript300
Master In SeleniumMukeshSelenium3000
Master In JavaAmodJAVA2000
Master In JSAmitJavascript1000

How to Handle Static Table Elements

There is nothing complicated in handling the table elements or cells. All you can do is inspect the table cell and get that. For that, you can use the different locators, but if you are not aware of those, you can write a common locator that helps you locate the elements with the XPath locators.

Handle Static Web Table in Selenium
Handle Static Web Table in Selenium

Below, we will discuss a few scenarios of how you can retrieve the required data from different rows or columns of the table.

How to print all the table header values.

As you can see, header values are a row with <th> and <tr> tags. So let us go to understand how we can retrieve the values from the table:

1. Locate the complete table header, which is the first row. so we need to locate and complete the full header with the Xpath locators, and after that, we can retrieve each cell value by a loop.

package com.selenium.practice.table;

import java.util.List;
import java.util.concurrent.TimeUnit;

import org.openqa.selenium.By;
import org.openqa.selenium.WebDriver;
import org.openqa.selenium.WebElement;
import org.openqa.selenium.chrome.ChromeDriver;
public class StaticTable_FindTableHeaderEx 
{
   public static void main(String[] args) 
   {
      WebDriver driver;
      System.setProperty("webdriver.chrome.driver","Path Of Browser Driver");

      //When The Checkboxes have an Unique ID
      driver=new ChromeDriver();
      driver.manage().window().maximize();
      driver.get("https://softwaretestingo.blogspot.com/2020/09/static-table.html");
      driver.manage().timeouts().implicitlyWait(15000, TimeUnit.SECONDS);
      
      List<WebElement> allHeadersOfTable= driver.findElements(By.xpath("//table[@name='BookTable']/tbody/tr/th"));
      System.out.println("Headers in table are below:");
      System.out.println("Total headers found: "+allHeadersOfTable.size());
      for(WebElement header:allHeadersOfTable)
      {
         System.out.println(header.getText());
      }
   }
}

Find the number of columns for each row:

For a static table, the column is always the same for all the columns, but when dealing with a dynamic table, you can find out that some row sizes are different. So, in that case, how do you find the number of cells in each row using the below script

package com.selenium.practice.table;

import java.util.List;
import java.util.concurrent.TimeUnit;

import org.openqa.selenium.By;
import org.openqa.selenium.WebDriver;
import org.openqa.selenium.WebElement;
import org.openqa.selenium.chrome.ChromeDriver;
public class StaticTable_FindNuberOfColumns 
{
   public static void main(String[] args) 
   {
      WebDriver driver;
      System.setProperty("webdriver.chrome.driver","Path Of Browser Driver");

      //When The Checkboxes have an Unique ID
      driver=new ChromeDriver();
      driver.manage().window().maximize();
      driver.get("https://softwaretestingo.blogspot.com/2020/09/static-table.html");
      driver.manage().timeouts().implicitlyWait(15000, TimeUnit.SECONDS);

      List<WebElement> allRows= driver.findElements(By.xpath("//table[@name='BookTable']/tbody/tr"));
      
      // We will start from 2nd row as 1st row is header
      for(int i=2;i<=allRows.size();i++)
      {
         List<WebElement> allColumnsInRow=driver.findElements(By.xpath("//table[@name='BookTable']/tbody/tr["+i+"]/td"));
         System.out.println("Number of columns in "+(i-1)+" data row is:"+allColumnsInRow.size());
      }
      
      driver.close();
   }
}

Retrieve the name of the book whose author is Mukesh:

In the above table, you can see that the second column is for an author, so first, we will try to get the author’s name, and with that value, we will match it with the given author value. If both the values are matched, we will get the book name value from the first column because that represents the book name.

package com.selenium.practice.table;

import java.util.List;
import java.util.concurrent.TimeUnit;

import org.openqa.selenium.By;
import org.openqa.selenium.WebDriver;
import org.openqa.selenium.WebElement;
import org.openqa.selenium.chrome.ChromeDriver;
public class StaticTable_FindBooksWrittenByMukesh 
{
   public static void main(String[] args) 
   {
      WebDriver driver;
      System.setProperty("webdriver.chrome.driver","Path Of Browser Driver");

      //When The Checkboxes have an Unique ID
      driver=new ChromeDriver();
      driver.manage().window().maximize();
      driver.get("https://softwaretestingo.blogspot.com/2020/09/static-table.html");
      driver.manage().timeouts().implicitlyWait(15000, TimeUnit.SECONDS);

      List<WebElement> allRows= driver.findElements(By.xpath("//table[@name='BookTable']/tbody/tr"));

      // We will start from 2nd row as 1st row is header
      for(int i=2;i<=allRows.size();i++)
      {
         WebElement authorColumn=driver.findElement(By.xpath("//table[@name='BookTable']/tbody/tr["+i+"]/td[2]"));
         if(authorColumn.getText().toLowerCase().equalsIgnoreCase("Mukesh"))
         {
            WebElement bookNameColumns=driver.findElement(By.xpath("//table[@name='BookTable']/tbody/tr["+i+"]/td[1]"));
            System.out.println(bookNameColumns.getText());
         }

      }

      driver.close();
   }
}

The other way we can do the same thing with the help of the text() method. In this way, we are trying to locate all those author names whose names are Mukesh, and based on that, we will select the book name.

package com.selenium.practice.table;

import java.util.List;
import java.util.concurrent.TimeUnit;

import org.openqa.selenium.By;
import org.openqa.selenium.WebDriver;
import org.openqa.selenium.WebElement;
import org.openqa.selenium.chrome.ChromeDriver;
public class StaticTable_FindBooksWrittenByMukeshAnotherWay 
{
   public static void main(String[] args) 
   {
      WebDriver driver;
      System.setProperty("webdriver.chrome.driver","Path Of Browser Driver");

      //When The Checkboxes have an Unique ID
      driver=new ChromeDriver();
      driver.manage().window().maximize();
      driver.get("https://softwaretestingo.blogspot.com/2020/09/static-table.html");
      driver.manage().timeouts().implicitlyWait(15000, TimeUnit.SECONDS);

      System.out.println("Books written by Mukesh are below:");
      List<WebElement> allColumnsInRow=driver.findElements(By.xpath("//table[@name='BookTable']/tbody/tr/td[text()='Mukesh']/../td[1]"));
      for(WebElement e: allColumnsInRow)
      {
         System.out.println(e.getText());
      }
      driver.close();
   }
}

List all books whose price is greater than or equal to 1000

We can do this by like below

package com.selenium.practice.table;

import java.util.List;
import java.util.concurrent.TimeUnit;

import org.openqa.selenium.By;
import org.openqa.selenium.WebDriver;
import org.openqa.selenium.WebElement;
import org.openqa.selenium.chrome.ChromeDriver;
public class StaticTable_FindBooksWhosePriceisMoreThen1000 
{
   public static void main(String[] args) 
   {
      WebDriver driver;
      System.setProperty("webdriver.chrome.driver","Path Of Browser Driver");

      //When The Checkboxes have an Unique ID
      driver=new ChromeDriver();
      driver.manage().window().maximize();
      driver.get("https://softwaretestingo.blogspot.com/2020/09/static-table.html");
      driver.manage().timeouts().implicitlyWait(15000, TimeUnit.SECONDS);

      List<?> allRows= driver.findElements(By.xpath("//table[@name='BookTable']/tbody/tr"));
      // Print book name whose price is greater than and equal to 1000
      System.out.println("Books with price greater than and equal to 1000 are below:");
      for(int i=2;i<=allRows.size();i++)
      {
         WebElement priceColumn=driver.findElement(By.xpath("//table[@name='BookTable']/tbody/tr["+i+"]/td[4]"));
         if(Integer.parseInt(priceColumn.getText())>=1000)
         {
            WebElement bookName=driver.findElement(By.xpath("//table[@name='BookTable']/tbody/tr["+i+"]/td[1]"));
            System.out.println(bookName.getText());
         }
      }

      driver.close();
   }
}

During the discussion on Xpath, we discussed last(). We can use the same method here to select the last row; after that, we can use a loop to get the values of the cells of that row.

The total print cost of all the books listed in the table

We can also collect the value of each cell of the price column by using the text() method, and then we can convert those string values into an integer. After that, we can add all those values to get the total values.

package com.selenium.practice.table;

import java.util.List;
import java.util.concurrent.TimeUnit;

import org.openqa.selenium.By;
import org.openqa.selenium.WebDriver;
import org.openqa.selenium.WebElement;
import org.openqa.selenium.chrome.ChromeDriver;
public class StaticTable_FindTotalCostsOfAllBooks 
{
   public static void main(String[] args) 
   {
      WebDriver driver;
      System.setProperty("webdriver.chrome.driver","Path Of Browser Driver");

      //When The Checkboxes have an Unique ID
      driver=new ChromeDriver();
      driver.manage().window().maximize();
      driver.get("https://softwaretestingo.blogspot.com/2020/09/static-table.html");
      driver.manage().timeouts().implicitlyWait(15000, TimeUnit.SECONDS);

      // find the sum of the cost of all books listed
      List<WebElement> costColumns= driver.findElements(By.xpath("//table[@name='BookTable']/tbody/tr/td[4]"));
      int sum_price=0;
      for(WebElement e : costColumns)
      {
         sum_price= sum_price+Integer.parseInt(e.getText());
      }
      System.out.println("total price: "+sum_price);

      driver.close();
   }
}

Retrieving the cell value of a specific column of a specific row

We can mention the specific row and column value in the XPath to get only our required value from the table to get a specified cell value.

// Retrive cell value by providing row and column number
WebElement colValue= driver.findElement(By.xpath("//table[@name='BookTable']/tbody/tr[2]/td[3]"));
System.out.println(colValue.getText());

the above method is static, but we can customize the same method so that by only passing the row and column value to that method, we can easily get that value.

public static String getColValue(int row, int col, WebDriver driver)
{
   WebElement colValue= driver.findElement(By.xpath("//table[@name='BookTable']/tbody/tr["+row+"]/td["+col+"]"));
   return colValue.getText();
}

Finding column index using the column name

Suppose you want to get the average value of the price, but you don’t know which column is for the price; in this case, we need to get all the values of the header, and after that, we need to iterate each header value and need to compare with the price. If the table header value matches the price column name, we can get the count, and from that, we can get the index.

// Printing column index based on column name
List allHeadersOfTable2= driver.findElements(By.xpath("//table[@name='BookTable']/tbody/tr[1]/th"));
for(int k=0;k<allHeadersOfTable2.size();k++)
{
   if(allHeadersOfTable2.get(k).getText().equalsIgnoreCase("price"))
   {
      System.out.println("Column index of Price column is: "+(k+1));
   }
}

The Complete Program

package com.selenium.practice.table;

import java.util.List;
import java.util.concurrent.TimeUnit;
import org.openqa.selenium.By;
import org.openqa.selenium.WebDriver;
import org.openqa.selenium.WebElement;
import org.openqa.selenium.chrome.ChromeDriver;

public class HandlingWebTable 
{
   public static void main(String[] args) 
   {
      System.out.println("Execution Starts");
      WebDriver driver;
      System.setProperty("webdriver.chrome.driver","Path Of Browser Driver");

      //When The Checkboxes have an Unique ID
      driver=new ChromeDriver();
      driver.manage().window().maximize();
      driver.get("https://softwaretestingo.blogspot.com/2020/09/static-table.html");
      driver.manage().timeouts().implicitlyWait(15000, TimeUnit.SECONDS);

      // Printing table header of a web table assuming first row as header
      System.out.println("Printing all header of table assuming first row as header: ");
      List<WebElement> allHeadersOfTable= driver.findElements(By.xpath("//table[@name='BookTable']/tbody/tr[1]/th"));
      System.out.println("Headers in table are below:");
      System.out.println("Total headers found: "+allHeadersOfTable.size());
      for(WebElement header:allHeadersOfTable)
      {
         System.out.println(header.getText());
      }
      System.out.println("==================================");

      // Printing table header of a web table assuming no information about header row
      System.out.println("Printing all header of table without information of row header ");
      List<WebElement> allHeadersOfTable1= driver.findElements(By.xpath("//table[@name='BookTable']/tbody/tr/th"));
      System.out.println("Headers in table are below:");
      System.out.println("Total headers found: "+allHeadersOfTable1.size());
      for(WebElement header:allHeadersOfTable1)
      {
         System.out.println(header.getText());
      }
      System.out.println("==================================");

      // Finding number of rows in a web table. We need to exclude header to get actual number of data rows
      System.out.println("Retrieving total number of data rows:");
      List<WebElement> allRows= driver.findElements(By.xpath("//table[@name='BookTable']/tbody/tr"));
      System.out.println("Total data rows found in table:"+ (allRows.size()-1));
      System.out.println("=====================================================================");

      // Find the number of columns in each row
      System.out.println("Retrieving total number of columns for each row:");
      for(int i=2;i<=allRows.size();i++)
      {
         List<WebElement> allColumnsInRow=driver.findElements(By.xpath("//table[@name='BookTable']/tbody/tr["+i+"]/td"));
         System.out.println("Number of columns in "+(i-1)+" data row is:"+allColumnsInRow.size());
      }
      System.out.println("==================================");

      //Print each row and columns from web table
      System.out.println("Printing all column value: ");
      for(int i=2;i<=allRows.size();i++)
      {
         List<WebElement> allColumnsInRow=driver.findElements(By.xpath("//table[@name='BookTable']/tbody/tr["+i+"]/td"));
         for(int j=0;j<allColumnsInRow.size();j++)
         {
            System.out.print(((WebElement) allColumnsInRow.get(j)).getText()+" ");
         }
         System.out.println();
      }
      System.out.println("==================================");

      // List books name and price whose author is mukesh
      System.out.println("Way 1: Books written by Mukesh are below:");
      for(int i=2;i<=allRows.size();i++)
      {
         WebElement authorColumn=driver.findElement(By.xpath("//table[@name='BookTable']/tbody/tr["+i+"]/td[2]"));
         if(authorColumn.getText().toLowerCase().equalsIgnoreCase("Mukesh"))
         {
            WebElement bookNameColumns=driver.findElement(By.xpath("//table[@name='BookTable']/tbody/tr["+i+"]/td[1]"));
            System.out.println(bookNameColumns.getText());
         }
      }
      System.out.println("==================================");

      // Another shortcut way
      System.out.println("Way 2: Books written by Mukesh are below:");
      List<WebElement> allColumnsInRow=driver.findElements(By.xpath("//table[@name='BookTable']/tbody/tr/td[text()='Mukesh']/../td[1]"));
      for(WebElement e: allColumnsInRow)
      {
         System.out.println(e.getText());
      }

      // Print book name whose price is greater than and equal to 1000
      System.out.println("==================================");
      System.out.println("Books with price greater than and equal to 1000 are below:");
      for(int i=2;i<=allRows.size();i++) { WebElement priceColumn=driver.findElement(By.xpath("//table[@name='BookTable']/tbody/tr["+i+"]/td[4]")); if(Integer.parseInt(priceColumn.getText())>=1000)
      {
         WebElement bookName=driver.findElement(By.xpath("//table[@name='BookTable']/tbody/tr["+i+"]/td[1]"));
         System.out.println(bookName.getText());
      }
      }
      System.out.println("==================================");

      // How to print data from the last row
      System.out.println("Directly printing column values of last row of table: ");
      List<WebElement> columnOfLastRow= driver.findElements(By.xpath("//table[@name='BookTable']/tbody/tr[last()]/td"));
      for(WebElement e:columnOfLastRow)
      {
         System.out.println(e.getText());
      }
      System.out.println("==================================");
      // find sum of cost of all books listed

      List<WebElement> costColumns= driver.findElements(By.xpath("//table[@name='BookTable']/tbody/tr/td[4]"));
      int sum_price=0;
      for(WebElement e:costColumns)
      {
         sum_price= sum_price+Integer.parseInt(e.getText());
      }
      System.out.println("total price: "+sum_price);
      System.out.println("==================================");

      // Retrieve cell value by providing row and column number
      WebElement colValue= driver.findElement(By.xpath("//table[@name='BookTable']/tbody/tr[2]/td[3]"));
      System.out.println("Cell Value : "+colValue.getText());
      System.out.println("==================================");
      System.out.println("Cell value using custom method: "+HandlingWebTable.getColValue(2, 3, driver));

      // Printing column index based on the column name
      List<WebElement> allHeadersOfTable2= driver.findElements(By.xpath("//table[@name='BookTable']/tbody/tr[1]/th"));
      for(int k=0;k<allHeadersOfTable2.size();k++)
      {
         if(allHeadersOfTable2.get(k).getText().equalsIgnoreCase("price"))
         {
            System.out.println("Column index of Price column is: "+(k+1));
         }

      }

      driver.quit();

   }

   public static String getColValue(int row, int col, WebDriver driver)
   {
      WebElement colValue= driver.findElement(By.xpath("//table[@name='BookTable']/tbody/tr["+row+"]/td["+col+"]"));
      return colValue.getText();

   }

}

Output:

Printing all header of table assuming first row as header: 
Headers in table are below:
Total headers found: 4
BookName
Author
Subject
Price
=====================================================================
Printing all header of table without information of row header 
Headers in table are below:
Total headers found: 4
BookName
Author
Subject
Price
=====================================================================
Retrieving total number of data rows:
Total data rows found in table:6
=====================================================================
Retrieving total number of columns for each row:
Number of columns in 1 data row is:4
Number of columns in 2 data row is:4
Number of columns in 3 data row is:4
Number of columns in 4 data row is:4
Number of columns in 5 data row is:4
Number of columns in 6 data row is:4
=====================================================================
Printing all column value: 
Learn Selenium Amit Selenium 300 
Learn Java Mukesh Java 500 
Learn JS Animesh Javascript 300 
Master In Selenium Mukesh Selenium 3000 
Master In Java Amod JAVA 2000 
Master In JS Amit Javascript 1000 
=====================================================================
Way 1: Books written by Mukesh are below:
Learn Java
Master In Selenium
=====================================================================
Way 2: Books written by Mukesh are below:
Learn Java
Master In Selenium
========================================================================
Books with price greater than and equal to 1000 are below:
Master In Selenium
Master In Java
Master In JS
========================================================================
Directly printing column values of last row of table: 
Master In JS
Amit
Javascript
1000
========================================================================
total price: 7100
========================================================================
Cell Value : Selenium
========================================================================
Cell value using custom method: Selenium
Column index of Price column is: 4

Avatar for Softwaretestingo Editorial Board

I love open-source technologies and am very passionate about software development. I like to share my knowledge with others, especially on technology that's why I have given all the examples as simple as possible to understand for beginners. All the code posted on my blog is developed, compiled, and tested in my development environment. If you find any mistakes or bugs, Please drop an email to softwaretestingo.com@gmail.com, or You can join me on Linkedin.

Leave a Comment