We can use an Excel sheet as a source of input. We can access data from excel sheet using DataProvider annotation and pass arguments through @Test methods. Mainly this approach is used in Data Driven Framework.

Data Driven Framework: A data-driven framework is used to run the same script for a huge amount of test data from any source like properties files, excel files etc. On the other hand, a Key Driven framework is based on keywords which are used to control the execution of the script without modifying the actual code. A tester has to just set the keywords which he/she wants to execute during a review cycle. Nowadays, the hybrid framework is used which is the combination of Keyword Driven and Data Driven Framework.
Please refer Simple example of Key Driven Framework using the excel sheet.
DataProvider
A data provider is defined with @DataProvider annotation. This annotation contains only one attribute its name. If the name is not supplied, the data provider’s name automatically defaults to the method’s name. A data provider returns an array of objects as mentioned below:
The return type of methods using “@DataProvider(name=”testdata”)” should be Object[Row][Col].
Row – defines the number of rows in excel files
– It also defines the total number of times test get repeat and it treats it as individual test case in TestNg
Col – defines number of columns in excel file
– defines total number of parameters in the test data
@DataProvider(name=“excelData”)
public Object[ ][ ] readExcel()
{
Object[ ][ ] obj=new Object[2][2];
return obj;
}
@Test(dataProvider=“excelData”)
Public void testMethod(String arg1, String arg2)
{
System.out.println(arg1);
System.out.println(arg2);
}
Selenium Code:
import java.io.File; import java.io.FileInputStream; import java.io.IOException; import org.apache.poi.xssf.usermodel.XSSFSheet; import org.apache.poi.xssf.usermodel.XSSFWorkbook; import org.openqa.selenium.By; import org.openqa.selenium.WebDriver; import org.openqa.selenium.chrome.ChromeDriver; import org.openqa.selenium.support.ui.ExpectedConditions; import org.openqa.selenium.support.ui.WebDriverWait; import org.testng.Assert; import org.testng.annotations.BeforeClass; import org.testng.annotations.DataProvider; import org.testng.annotations.Test; public class TestCase { public static WebDriver driver; public static String targetURL="https://gmail.com"; @BeforeClass public void launchURL() { System.setProperty("webdriver.chrome.driver", "exe\\chromedriver.exe"); driver=new ChromeDriver(); driver.get(targetURL); } @DataProvider(name="excelData") public Object[][] readExcel() throws IOException { File file=new File("data\\testData.xlsx"); FileInputStream fis=new FileInputStream(file); XSSFWorkbook workbook= new XSSFWorkbook(fis); XSSFSheet sheet=workbook.getSheet("Sheet1"); int totalRows=sheet.getLastRowNum(); int totalColums=sheet.getRow(0).getPhysicalNumberOfCells(); // Read data from excel and store the same in the Object Array. Object obj[][]=new Object[totalRows][totalColums]; for(int i=0;i<totalRows;i++) { obj[i][0]=sheet.getRow(i+1).getCell(0).toString(); obj[i][1]=sheet.getRow(i+1).getCell(1).toString(); } return obj; } @Test(dataProvider="excelData") public void validateUser(String userName,String password) throws InterruptedException { By userNameXpath=By.xpath(".//*[@id='identifierId']"); By nextBtnXpath=By.xpath(".//*[@id='identifierNext']"); By passwordXpath=By.xpath(".//*[@id='password']//input[contains(@name,'password')]"); By passwordNextBtnXpath=By.xpath(".//*[@id='passwordNext']"); By searchXpath=By.xpath("//input[contains(@aria-label,'Search')]"); wait(userNameXpath); driver.findElement(userNameXpath).click(); driver.findElement(userNameXpath).clear(); driver.findElement(userNameXpath).sendKeys(userName); driver.findElement(nextBtnXpath).click(); wait(passwordXpath); driver.findElement(passwordXpath).click(); driver.findElement(passwordXpath).sendKeys(password); driver.findElement(passwordNextBtnXpath).click(); try { wait(searchXpath); String windowTitle=driver.getTitle(); if(windowTitle.contains(userName)) { Assert.assertTrue(true); logout(); switchAccount(); } else { Assert.assertTrue(false); } } catch(Exception e) { switchAccount(); Assert.assertTrue(false); } } public void wait(By locator) { WebDriverWait wait=new WebDriverWait(driver, 10); wait.until(ExpectedConditions.visibilityOfElementLocated(locator)); } public void logout() throws InterruptedException { By myProfileXpath=By.xpath("//*[contains(@href,'SignOutOptions')]"); By logoutBtnXpath=By.xpath("//*[contains(@href,'Logout')]"); driver.findElement(myProfileXpath).click(); wait(logoutBtnXpath); driver.findElement(logoutBtnXpath).click(); } public void switchAccount() { By switchAccountXpath=By.xpath("//div[contains(@aria-label,'Switch account')]"); By useOtherAccountXpath=By.xpath("//*[@id='identifierLink']"); wait(switchAccountXpath); driver.findElement(switchAccountXpath).click(); wait(useOtherAccountXpath); driver.findElement(useOtherAccountXpath).click(); } }
TestNG:
- TestNG – 1 || Introduction and benefits of TestNG Framework.
- TestNG – 2 || Installation process and a sample program of TestNG.
- TestNG – 3 || Create and execute multiple Test Cases.
- TestNG – 4 || Let’s understand @Test Annotation and attributes.
- TestNG – 5 || Understand Assertion in TestNG.
- TestNG – 6 || Use of @BeforeMethod and @AfterMethod.
- TestNG – 7 || Use of @BeforeClass and @AfterClass.
- TestNG – 8 || Creation and execution of Test Suites.
- TestNG – 9 || Let’s move deep into the Test Suites.
- TestNG – 10 || Use @BeforeTest and @AfterTest Annotations.
- TestNG – 11 || Groups attribute with @Test Annotation.
- TestNG – 12 || Use of @BeforeGroups & @AfterGroups.
- TestNG – 13 || Use of @BeforeSuite & @AfterSuite.
- TestNG – 14 || DataProvider annotation & attribute.
- TestNG – 15 || DataProvider with parameters.
- TestNG – 16 || Access data from Excel sheet using DataProvider.
- TestNG – 17 || Passing multiple Parameters in testng xml.
- TestNG – 18 || Multiple Browser and Parallel Execution in TestNG.
- TestNG -19 || Concept of Parallel Execution.
- TestNG – 20 || Run TestNG Program using main() method.
Computer Basics:
- Computer Basics -1 || Introduction and Structure of Computer.
- Computer Basics -2 || Types of Computers and Usage.
- Computer Basics -3 || What are the different types of Software?
- Computer Basics -4 || Importance of Operating System(OS).
- Computer Basics -5 || Understanding of Number System.
- Computer Basics -6 || Understanding MS-DOS Commands.
- Computer Basics -7 || Important Features of MS-Word.
- Computer Basics -8 || Let’s learn the usage of MS-Excel.
- Computer Basics -9 || Understand and Implement Data Validation in Excel.
- Computer Basics -10 || How to apply Filter in a data set in Excel?
- Computer Basics -11 || Using Charts in place of Data Tables in Excel.
- Computer Basics -12 || Advantages of PivotCharts over Simple Charts in Excel.
- Computer Basics -13 || Creating pivot charts/tables in Excel.
- Abbreviations to Full-Forms in Computer Basics.
Java Basics:
- Basic Java – 1 || Understand Java before start learning JAVA.
- Basic Java – 2 || Variables and Data Types used in JAVA.
- Basic Java – 3 || Understanding Class, Objects, Methods in Java.
- Basic Java – 4 || More on methods(Return Type and Parameters)
- Basic Java – 5 || Methods- Call by Value and Call by Reference in Java.
- Basic Java – 6 || Understanding of Constructor and Destructor in JAVA.
- Basic Java – 7 || Static Variables and Methods.
- Basic Java – 8 || Lets learn about Arrays in Java.
- Basic Java – 9 || Performing multiple operations using Java Operators.
- Basic Java – 10 || Conditions (If and Switch) in JAVA.
- Basic Java – 11 || for and for-each in Java. (Loops Part-1)
- Basic Java – 12 || Alternate looping concepts while and do-while. (Loops Part-2)
- Basic Java – 13 || Decimal values v/s Octal base(8) values in JAVA.
- Basic Java – 14 || Learn about String literals in Java.
- Basic Java – 15 || Runtime User Input using Scanner Class (Part-1).
- Basic Java – 16 || Runtime User Input using BufferedReader Class (Part-2).
- Basic Java – 17 || Runtime User Input using Console Class (Part-3).
- Basic Java – 18 || Difference between break and continue keywords.
- Basic Java – 19 || Sending Email using Java (Part-1).
- Basic Java – 20 || Sending Email with attachment using Java (Part-2).
- Basic Java – 21 || Stack memory and Heap memory in Java.
- Basic Java – 22 || Let’s learn more about String.
- Basic Java – 23 || String, StringBuffer & StringBuilder in Java.
- Basic Java – 24 || Exception Handling using Try Catch.
- File Handling | Reading data from word document(.doc or .docx) in JAVA.
- File Handling | Reading data from Excel files (.xls or .xlsx) using JAVA.
- File Handling | Writing data into an Excel(.XLSX or .XLS) File.
- File Handling | Implement formatting in Excel using Java.
- File Handling | Copy existing data from one workbook to another workbook in Java.
- File Handling | Reading data from PDF file using JAVA.
- File Handling || Traverse folders and subfolders in Java.
- File Handling || Reading and Writing data from a text file.
- File Handling || Multiple file creation using template based input data.
- Framework || Simple example of Key Driven Framework using excel sheet in Selenium(JAVA).
- QnA || How to use Constructors in Abstract class?
- QnA | Difference between Integer and int keywords.
- QnA | Can main method be overloaded?
- QnA | How do I reverse a String/Sentence in Java?
- QnA | Perform Multiplication and Division without * or / or % operators.
- QnA | How do I get the default value of data type?
- QnA | How to split String if it contains period symbol (.) in between?
- Different ways to Reverse a String in Java.
- Copy formatting & style of cells from one sheet to another.
- Getting IP address and Hostname using InetAddress Class.
- User inputs via Command Prompt using arguments of main() method of a class.
- Program for List and ArrayList in Java.
- Useful methods and implementation under Scanner Class.
- Swapping two variable values without using any third variable.
- Difference between int x= 10 and y=010 in Java.
- Parameterized Constructors v/s Setter and Getter function in JAVA.
- Override a Static Method.
- Selenium-12 || Select Class to handle drop-down.
- Selenium-11 || Use of Actions and Action Classes.
- Selenium-10 || Taking Screenshots using Selenium
- Selenium-9 || Understanding WebDriver API.
- Selenium-8 || Implementing Wait(s) in Selenium.
- Selenium-7 || Let’s learn to create complex XPath.
- Selenium-6 || XPath is the best way to locate web elements.
- Selenium-5 || Locating web elements using various type of Locators.
- Selenium-4 || Handling multiple web browsers.
- Selenium-3 || First program using Selenium Web Driver.
- Selenium-2 || Let’s learn Selenium IDE.
- Selenium-1 || Understanding Selenium and Selenium WebDriver.
- JIRA Tutorials-2 || Implement Search and Filter on JIRA Issues.
- JIRA Tutorials-1 || Basic understanding of JIRA.