Add Required .xls Files of Data

Till now we have created the project structure & added the required class files in the project. Here, we will discuss about the required DataSheet.xlsx file & the template for the DataSheet.

Download the attached DataSheet.xlsx template from here & place the file in src/test/resources directory.

Please open the attached DataSheet.xlsx file & compare the below items in the data sheet.

Sheets:

1.       Test Cases         : This sheet will have two columns.

1.1.1         Test Case Name               : The name of the test cases

1.1.2         Runmode                          : To decide whether we will execute the test case or not.

2.       Data                   : This sheet will contain the actual test data required for each test cases. The sheet will have below column names:

2.1.1         Description                    : This column should have the brief description about the scenario.

2.1.2         Runmode                       : To decide whether we will execute the test data or not.

2.1.3         ExpectedResult              : The expected result of that test scenario.

2.1.4         ……    2.1.n                  : The no.of fields present in the web page.

Rules while creating the test data:

1.       In test cases sheet, we should write the name of the test cases without any gap & will provide the Runmode as Y – for execution & N – for Skipping the test case.

2.       In Data sheet, the 1^st cell value will be same as the test case name.

3.       In Row2 we should define the column names.

4.       There should be a blank line between each test case.

<<<Prev       Next>>>