Another additional feature provided by the Bqurious C-SAPS™ platform is using the data from MS Excel.
Let us try to understand this feature better with the help of an example.
Suppose you have created a test case and you wish to enter the data in the test case from an excel file.
All you need to do is attach the excel file in External Test Data of the DESIGN section.
Follow the below steps to attach the .xls file.
1- Tap on 'External Test Data' option from DESIGN section.
You will be greeted with the following screen.
2- Click on Add Data File button.
3- Enter the File description and click on Save button.
4- Click on the highlighted area to attach the .xls file.
5- Navigate to the test case screen.
Once you attach the .xls file, the file will be listed in 'Data File' dropdown of the test case detail screen.
6- Select the attached file and tap on Test Steps tab.
7- Click on Data button next to the 'setValue' keyword.
8- Select 'Excel' datatype from the Value dropdown.
9- Enter the value as the name of the column (in .xls file), from which the data needs to be fetched.
10- Tap on the Update button.
11- Add a keyword 'setExcelRow' just above the setValue keyword.
The updated test script image is displayed below.
11- Save and execute the test case.