How to use data from MS Excel ?

Owned by
Abhay Goel
Last updated: Mar 06, 2023 by
Shivangi Sah
2 min read

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.

Lets assume that the excel file has the below data

 

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. Enter the desired data’s row number in setExcelRow keyword.

     The updated test script image is displayed below.
       

11- Save and execute the test case.

 





Â