Data driven software testing framework for selenium webdriver should be able to report the software test suite results In excel files. We have achieved goal of reporting test failure In testng reports In STEP 16. Now let us try to achieve our next goal of reporting software test cases's results In excel files.

STEP 17

In selenium webdriver automated data driven framework creation process, We have Implemented total 15 steps till now and we have successfully achieved our goal of reporting software application's test data results In excel sheets In step 15. We are going very slowly to create data driven framework for your better understanding.

STEP 16

STEP 15
Prerequisite : Selenium WebDriver Framework creation steps from STEP 1 to STEP 14 should be Implemented as described In previous posts.

We have Implemented software test data skip function In STEP 14. Now let we go ahead one more step In selenium testing data driven framework creation. If you know, We have a "Pass/Fail/Skip" column In our excel data

STEP 14
Prerequisite : STEP 1 to STEP 13 of creating data driven framework for selenium webdriver software testing tool should be Implemented.

If you know, we need very custom data driven framework for selenium webdriver where you can skip specific software test suite, specific test case or specific data set line too from your software test execution whenever required.

STEP 13
PrerequisiteSTEP 1 to STEP 12 should be Implemented as described.

In previous two steps, We have learnt how to skip specific software automation test suite's execution from your test and then reported software test suite execution status In excel file. So this was our basic requirement of our selenium software automation framework which Is driven by data of external excel sheet.

STEP 12
Prerequisite : All previous (STEP 1 to STEP 11) selenium test framework creation steps should be Implemented.

As described In previous post, Your test execution status will be reported In testng report automatically by

STEP 11
Prerequisite : All previous selenium framework creation steps starting from STEP 1 to STEP 10 should be Implemented.

Right now we are at the middle of selenium Webdriver software automation framework creation process. Now next step Is to Implement software automation test suite skipping functionality In selenium data driven automation framework.

STEP 10
Prerequisite
1. All the previous steps starting from STEP 1 to STEP 9 should be Implemented properly.
2. TestNG software unit testing framework should be Installed properly In eclipse. VIEW TESTNG INSTALLATION GUIDE.

Now our all four test cases from both the suites are able to read data from related excel file as described In STEP 9 of data driven framework creation. But right now main Issue Is we need to run all four test cases

STEP 9
Prerequisite : STEP 1 to STEP 8 should be Implemented In data driven framework creation for webdriver software automation tool.

If you have followed all the data driven framework creating steps then I am sure that you will be succeed to read data from SuiteOneCaseOne test data sheet of SuiteOne.xls file for SuiteOneCaseOne test case as described In STEP 8. Now Its time to Implement same data reading test In all remaining 3 software test cases of both the test suites to make sure that everything Is fine till now In data driven framework creation for webdriver software automation tool.

STEP 8


PrerequisiteAll 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.

STEP 7

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

Till now we have performed many different actions on selenium webdriver software automation testing framework creation - Starting from work space creation to .xls files creation In STEP 1 to STEP 6. Now Its time to Introduce some

STEP 6

Prerequisite : All required class files should be created as described In STEP 5.

After creating all required classes under different packages, Now It Is time to create required .xls files. Please note here that this framework will not support .xlsx files but It will support only .xls files so please create only .xls files as described bellow. In our selenium WebDriver software testing Framework, We will

STEP 5

Prerequisite : Jar files should be added In software testing project's build path As described In Step 4.
(Special Note : Please don't skip any of the previous steps.).

Now Its time to create all required class(.java) files under different packages. In our selenium WebDriver software testing data driven framework, We have to create one base class for all the test suites of project. We have to

STEP 4
Prerequisite : Required jar files should be downloaded and stored In "JarFiles" folder as described In STEP 3.

In our selenium webdriver software automation testing framework, We are going to use Apache POI API software service for reading data from .xls file, Apache Logging software service to generate execution log, xslt reports to generate Interactive HTML reports of software web application test

STEP 3
Prerequisite : Project Structure should be created as described In Step 2.

Next step Is to download all required supporting jar files for our selenium webdriver software testing tool's data driven framework. Let me tell you which software jar files will be required for creating selenium webdriver data driven framework. First of all, we will download all of them one by one and then will store them In "JarFiles" folder which Is created under "WDDF" project In Step 2.

STEP 2
Prerequisite :
1. Work Space and software test Project should be created as described In Step 1.
(Special Note : Please follow each and every step throughout the selenium webdriver software automation testing tool's data driven framework creation. Don't skip any step.)

STEP 1
Prerequisite :
1. READ PREVIOUS POST about what Is webdriver data driven framework for software testing.
2. Eclipse Kepler Should Be Downloaded. VIEW THIS POST (Step 2 : Download and install Eclipse) to see from where to download eclipse. I am using Eclipse Kepler.

Selenium WebDriver Data Driven Framework

Meaning Of data driven keyword In any automation framework Is your test cases and suite will be driven by external data set feed. Data feed can be any type of data sheets like xls file, xlsx file, csv file etc. Main concept of data driven framework Is your test case will remain unchanged even If you change number of