Handle Web Table Dynamically In Selenium WebDriver

Whenever the pagem loads its take the table data dynamically and get the table data.

In this Example am going to take table data for the below table.

Source code :

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.firefox.FirefoxDriver;

import org.testng.annotations.AfterTest;

import org.testng.annotations.BeforeTest;

import org.testng.annotations.Test;

public class testpins {

WebDriver driver = new FirefoxDriver();

@BeforeTest

public void setup() throws Exception {

driver.manage().window().maximize();

driver.manage().timeouts().implicitlyWait(5, TimeUnit.SECONDS);

driver.get("http://www.moneycontrol.com/");

}

@AfterTest

public void tearDown() throws Exception {

driver.quit();

}

@Test

public void Handle_Dynamic_Webtable() {

// To locate table.

WebElement mytable = driver.findElement(By.xpath("//*[@id='tblrMC']"));

// To locate rows of table.

List<WebElement> rows_table = mytable.findElements(By.tagName("tr"));

// To calculate no of rows In table.

int rows_count = rows_table.size();

// Loop will execute till the last row of table.

for (int row = 0; row < rows_count; row++) {

// To locate columns(cells) of that specific row.

List<WebElement> Columns_row = rows_table.get(row).findElements(

By.tagName("td"));

// To calculate no of columns(cells) In that specific row.

int columns_count = Columns_row.size();

System.out.println("Number of cells In Row " + row + " are "

+ columns_count);

// Loop will execute till the last cell of that specific row.

for (int column = 0; column < columns_count; column++) {

// To retrieve text from that specific cell.

String celtext = Columns_row.get(column).getText();

System.out.println("Cell Value Of row number " + row

+ " and column number " + column + " Is " + celtext);

}

System.out

.println("--------------------------------------------------");

}

}

}

If you run the above code your output look like this,

Number of cells In Row 0 are 0

--------------------------------------------------

Number of cells In Row 1 are 5

Cell Value Of row number 1 and column number 0 Is Gabriel India

Cell Value Of row number 1 and column number 1 Is Nov 5th 2014

Cell Value Of row number 1 and column number 2 Is 83

Cell Value Of row number 1 and column number 3 Is 99.25

Cell Value Of row number 1 and column number 4 Is 19.00

--------------------------------------------------

Number of cells In Row 2 are 5

Cell Value Of row number 2 and column number 0 Is SKF India

Cell Value Of row number 2 and column number 1 Is Oct 8th 2014

Cell Value Of row number 2 and column number 2 Is 1116

Cell Value Of row number 2 and column number 3 Is 1472.50

Cell Value Of row number 2 and column number 4 Is 31.90

--------------------------------------------------

Number of cells In Row 3 are 5

Cell Value Of row number 3 and column number 0 Is Sonata Software

Cell Value Of row number 3 and column number 1 Is Oct 7th 2014

Cell Value Of row number 3 and column number 2 Is 127

Cell Value Of row number 3 and column number 3 Is 153.05

Cell Value Of row number 3 and column number 4 Is 20.37

--------------------------------------------------

Number of cells In Row 4 are 5

Cell Value Of row number 4 and column number 0 Is IFCI

Cell Value Of row number 4 and column number 1 Is Sep 24th 2014

Cell Value Of row number 4 and column number 2 Is 35

Cell Value Of row number 4 and column number 3 Is 43.30

Cell Value Of row number 4 and column number 4 Is 25.51

--------------------------------------------------

Number of cells In Row 5 are 5

Cell Value Of row number 5 and column number 0 Is Minda Industries

Cell Value Of row number 5 and column number 1 Is Sep 15th 2014

Cell Value Of row number 5 and column number 2 Is 434

Cell Value Of row number 5 and column number 3 Is 655.00

Cell Value Of row number 5 and column number 4 Is 51.03

--------------------------------------------------

PASSED: Handle_Dynamic_Webtable

Generate Customized ExcelReports Using TestNG in Selenium

There are many ways to Generate Reports in Selenium. Now I’d like to generate an excel reports. This report will give you the number test cases has been Passed and Failed or Skipped. It’s quite simple to generate this report. All you need to do is just giving a Proper Name and Destination Path (if you’re using the latest jar 4.0.1).

Note: TestNG is required. Without testNG this code won’t work.
There are few steps to be followed to generate Excel Reports. Here I am sharing the snippet.

Download the latest Jar from here ExcelReportGenerator version 4.0.1. Add this Jar into your project BuildPath.

If You’re using Jar 4.0.1 version then you can specify the desired location and File name in the code itself.

Follow the Steps Specified :

Step1: Create a Package ‘ExcelResults’ under your Project (Optional, if you’re using 4.0.1 version).

step2: Create  the test cases which you’d like to automate using TestNg (by using @Test, BeforeTest…….) as Shown.

import org.openqa.selenium.WebDriver;
import org.testng.annotations.Test;

public class Test_98 {
@Test(priority = 1)
public void VerfyingTestCaseID_001() {
System.out.println(“test”);
System.out.println(“this”);
}

@Test(priority = 2)
public void VerfyingTestCaseID_002() {
System.out.println(“test”);
System.out.println(“this”);
}

@Test(priority = 3)
public void VerfyingTestCaseID_003() {
System.out.println(“test”);
System.out.println(“this”);
}

@Test(priority = 4)
public void VerfyingTestCaseID_004() {
System.out.println(“test”);
System.out.println(“this”);
}

@Test(priority = 5)
public void VerfyingTestCaseID_005() {
System.out.println(“test”);
System.out.println(“this”);
Assert.assertEquals(“validText”, “InvalidText”);
}

@Test(priority = 6)
public void VerfyingTestCaseID_006() {
System.out.println(“test”);
System.out.println(“this”);
}

@Test(priority = 7)
public void VerfyingTestCaseID_007() {
System.out.println(“test”);
System.out.println(“this”);
Assert.assertEquals(“validText”, “InvalidText”);

}

@Test(priority = 8)
public void VerfyingTestCaseID_008() {
System.out.println(“test”);
System.out.println(“this”);
}

@Test(priority = 9)
public void VerfyingTestCaseID_009() {
System.out.println(“test”);
System.out.println(“this”);
}

@Test(priority = 10)
public void VerfyingTestCaseID_010() {
System.out.println(“test”);
System.out.println(“this”);
}

@Test(priority = 11)
public void VerfyingTestCaseID_011() {
System.out.println(“test”);
System.out.println(“this”);
Assert.assertTrue(false);
}

@Test(priority = 12)
public void VerfyingTestCaseID_012() {
System.out.println(“test”);
System.out.println(“this”);
Assert.assertTrue(false);

}

@Test(priority = 13)
public void VerfyingTestCaseID_013() {
System.out.println(“test”);
System.out.println(“this”);
}

@Test(priority = 14)
public void VerfyingTestCaseID_014() {
System.out.println(“test”);
System.out.println(“this”);
}
}

Step3 : Create a testng.xml file under your Project as Shown.

<suite name=”Build 2.0.1″>

<test name=”TestReport”>
<classes>
<class name=”Test_98″ />
</classes>
</test>
</suite>

Now Run the testng.xml file.

Step 4 : Now Create a Class ‘ExcelGenerate’  and paste the following code.

import java.io.IOException;

import javax.xml.parsers.ParserConfigurationException;

import org.xml.sax.SAXException;
public class ExcelGenerate {

public static void main(String[]args) throws ParserConfigurationException, IOException, SAXException
{
ExcelReportGenerator.generateExcelReport(“MyProject.xls”, “D:\\workspace”);

}
}

Step5: Refresh the package ‘ExcelResults’ (If you’re using older version).

Step5 : Results will be generated at your desired path given. (If you’re using 4.0.1 version).

Click here to see the generated report.

Now you see the excelReport Generated. Its so simple huh !!!

*If you see the columns in the excel were disturbed please change the settings or Use the latest Version. I have made this using  ‘Libre’.

Infosys Asked 3 Years Selenium Testing Position

From Java
---------------
1.What is the Difference between final,finally,finalize
2.what is the difference between Call by value and call by referance
3.How to find out the length of the string without using length function
4.How to find out the part of the string from a string
5.difference between throw & throws
6.What is binding(Early and Late binding)
He give Programes
1.Reverse a number
2.1,2,3,4,5,65,76,5,,4,33,4,34,232,3,2323,
find the biggest number among these
simple string programe.
what is exception types of exception
-----------------------------------------
From manual
----------------------------------------
what is the testcase technique
why we write test case.
bug life cycle
what are the different status of bug
what is the different between functional and smoke testing
what is STLC.
he gives a application & tell to write the scenario
some manual testing concepts
-----------------------------
From Selenium
-----------------------------
1.Explain ur roles and responsibilities
2.Explain Automation Life Cycle
3.Which Framework U have Used?
4.Explain Ur Framework
5.What are the things u stored in PageFactory ? Why ?
6.Explain TestNG
7.What are the annotations U have Used ?
8.What is Constructor
9.Where u have used constructor in Selenium?
10.Which model u have followed in ur company?
11.How do you handle dynamics objects in a webpage?
12.How do you handle untrusted SSL certificate in Webdriver?
13.What is the difference between beforemethod and beforetest?
14.How to verify a particular image and its size in a webpage?(Webpage has got many images out of which you have select particular one)
15.What is the use of DesiredCapabilities in Selenium WebDriver?
16.How do you know the Remote m/c details. Like OS, browsers details.
17.How do you find out active elements?