for(int m=1;m<=rows;m++)
{

for(int n=1;n<=columns;n++)
{

String data = driver.findElement(By.xpath("//*[@id='leftcontainer']/table/tbody/tr["+m+"]/td["+n+"]")).getText();
System.out.println(data);
Wvalues.add(data);

how could i print the rows and columns text values in selenium. and how could i get the xlvalues from rows and columns from excel sheet.

There are ways to do this simply using xpaths, but it can get kind of long and convoluted. However, if you happen to be using the .NET version of WebDriver, I’ve just released an extension called TableDriver.NET that makes working with tables and specifically finding rows by their contents much easier. You can find the project here: https://github.com/jkindwall/TableDriver.NET. Here’s a quick example of how its used:

Assuming we are working with the html table in section #1 of this article, and we want to look up how many points Eve Jackson has, with the TableDriver extension to WebDriver, the code would look like this:

Table table = Table.Create(driver.FindElement(By.Id(“main”)));
string points = table.FindCell(“Firstname=Eve&Lastname=Jackson”, “Points”).Element.Text;

There is now a Java version of TableDriver available here (https://github.com/jkindwall/TableDriver.Java)

I have find the solution to the problem you are facing
please use the two for loop to generate the xpath dynamically and it should work .It worked for me

Can anyone advice how to write the code for example there is web table with multiple rows and columns, one of column is “NAME” and other column is “CITY” and many other columns too. So to write the code to get the CITY column text value of Robert (NAME Column) in web table, and here multiple rows of info available.

can you please help in this issue?

hello,
You can use the xpath followed by /. (ex: //span[@class=’reply’]/.)
That this in List of webelements and iterate:

List element= driver.findElements(By.xpath(“//span[@class=’reply’]/.”));
For(WebElement el1: element)
{
String title=el1. .getAttribute(“title”);
system.out.println(title);
}

//store the table row’s in table_row object
ArrayList table_row =(ArrayList) table.findElements(By.tagName(“tr”));
//get the row count
int rowcount=table_row.size();
System.out.println(rowcount);
//traverse the row to get column
for(int row=1;row<rowcount;row++)
{
//store the row's colmun in row_column object

ArrayList row_column =(ArrayList) table_row.get(row).findElements(By.tagName(“td”));
//get the column size
int columncount=row_column.size();
System.out.println(row+”rows column count is”+columncount);
//traverse row’s column’s
//for(int col=0;col<columncount;col++)
{
//get the cell value
String cellValue=row_column.get(col).getText();
values.add(cellValue);
System.out.println(row+"rowth"+col+"colth"+cellValue);

}
}

// if you want to reduce the table row's column
you can reduce the for loop condition statement
for(int row=1;row<rowcount;row++)
you can change the rowcount to actual need row_count

same for column
for(int col=0;col<columncount;col++)
change the columncount to actual need columncount