Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.


Another additional feature provided by the Bqurious C-SAPS™ platform. is using the data from MS Excel. 

...

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.               Image Removed

...

You will be greeted with the following screen.               Image Removed   

...

2- Click on Image Removedon Add Data File button.

3- Enter the File description and click on Save button.               Image Removed

...

4- Click on the highlighted area to attach the .xls file.              Image Removed

...

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.              Image Removed

...

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.              Image Removed

...

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

...

Filter by label (Content by label)
sort
showLabelsfalse
max5
spacescom.atlassian.confluence.content.render.xhtml.model.resource.identifiers.SpaceResourceIdentifier@10213
sortmodified
showSpacefalse
modifiedreversetrue
typepage
cqllabel = "kb-how-to-article" and type = "page" and space = "BSD"
labelskb-how-to-article

...

hiddentrue

...