Creating Sample Data Reading Test In WebDriver Data Driven Framework

STEP 8

Prerequisite : All the steps from STEP 1 to STEP 7 should be followed properly as described.

We have added file reading utility In our selenium webdriver software automation testing data driven framework so now we are all set to read data from the .xls files. As you all know, Right now we have 2 test suites In our software automation testing framework and each test suite have 2 test cases. So total there are 2 test suites and 4 test cases In our software automation testing framework. And also we have created two separate .xls files for each test suite. So .xls files and their sheets mapping with the test suites and their test cases will be as bellow.

• com.stta.SuiteOne -> SuiteOne.xls
• SuiteOneCaseOne.java -> SuiteOneCaseOne Sheet
• SuiteOneCaseTwo.java -> SuiteOneCaseTwo Sheet
• com.stta.SuiteTwo -> SuiteTwo.xls
• SuiteTwoCaseOne.java -> SuiteTwoCaseOne Sheet
• SuiteTwoCaseTwo.java -> SuiteTwoCaseTwo Sheet

Download Required Files
Now let we try to read data from SuiteOneCaseOne test data Sheet of SuiteOne.xls  File for SuiteOneCaseOne.java test case. For that, You need to download bellow given 3 files.

1. Download SuiteBase.java File
2. Download SuiteOneBase.java File
3. Download SuiteOneCaseOne.java File

Now copy-paste above downloaded files one by one as described bellow to replace existing files.
(Note : It should replace existing file when paste It on package. It should not Insert new file.)

1. Paste SuiteBase.java File on com.stta.TestSuiteBase Package.
2. Paste SuiteOneBase.java File on com.stta.SuiteOne Package.
3. Paste SuiteOneCaseOne.java File on com.stta.SuiteOne Package.

SuiteBase.java File Explanation

Open this file In your eclipse and view the code. I have created Init() function In this file to Initialize all .xls file's paths.

Note : Your all .xls files must be located at bellow given path. If .xls files  are located at any other location then you have to change all file's path In SuiteBase.java too.

.xls File's Paths should Be : E:\backup\Training\WDDF\src\com\stta\ExcelFiles

SuiteOneBase.java File Explanation

This file do not have any function on this stage. It Is just child class of SuiteBase. Will Implement required functions later on.

SuiteOneCaseOne.java File Explanation

This Is our test case file. Using this file, we will read test data from .xls file and then print them In console. This file contains bellow given different functions and usage of all those functions Is described bellow.

• checkCaseToRun() : If you will look at this function, I have used TestNG @BeforeTest annotation above the function. That means It will be executed before the @Test annotation method or we can say before starting of test execution. It will call Init() function from SuiteBase class to Initialize .xls files and then set SuiteOne.xls file's path In FilePath variable.
• SuiteOneCaseOneTest() : This function has TestNG @Test annotation that means It will be executed after execution of @BeforeTest annotation function. Also used dataProvider with @Test annotation to accept test data from SuiteOneCaseOneData() dataprovider function. It will accept four string argument values On every Iteration.
• SuiteOneCaseOneData() : It will retrieve test data from SuiteOne.xls file's SuiteOneCaseOne sheet and return data to SuiteOneCaseOneTest() function.

Note : retrieveTestData(String wsName) function In Read_XLS.java file Is written In such a way so that always It will skip reading of last two columns of data sheet("DataToRun" and "Pass/Fail/Skip").

Running Sample .xls Data Reading Test

Now It Is time to run our sample data reading test to make sure that every thing Is fine.

• Right click on SuiteOneCaseOne.java file In eclipse and go to Run As -> TestNG Test as shown bellow.

It will execute your software test case using TestNG. @Test annotation method will be executed two times because there are two data rows In SuiteOneCaseOne test data sheet. On completion of test execution, You will see bellow given result In your console.

Console Result

TestNG Result

If you can see above results then everything Is fine till now In your software testing data driven framework creation. We succeed for running sample data reading test In our webdriver data driven framework.

<- Go To STEP 7

Go To STEP 9 ->