Datadriven Test Case - Only reading one row of values from the Excel Sheet Data

Help Test Cloud
,
1

I am working on the Academy example of UiBank Create Loan. First time the automation run correctly. But after that its only reading one row of values. For example if the excel has 5 rows of data, its testing only row of data 5 times. I already tries removing the test data from the workflow and attaching it again.

Please suggest.
thanks

2

@SVC

Can you show us how you are using it and how it is configured

Cheers

3

Hi @SVC ,

  1. Check the variable being used in the For Each Row activity. Make sure it is the correct Excel sheet variable and that it has the correct range of rows set.
  2. Check the range of rows in the Excel sheet. Ensure that all the rows you want to iterate through are within the range specified in the For Each Row activity.
  3. Check the loop body of the For Each Row activity. Ensure that the values are being read from the correct columns and that they are being stored in the correct variables.
  4. If the Excel file is open while the automation is running, try closing it to see if that resolves the issue.
4

@SVC ,

Data Driven testing will work for only one record at a time. If you need to run others then you need to select check box data for all the data and run it. So test cases will run into batch one by one.

you can select as below from studio if you are running.

image
image1085×438 46.1 KB

Similarly you can do from orchestrator select data set to run.

Thanks,
Arvind.

1 Like
5

Thank you all for the suggestions. I used data driven testcase and attached the excel data with the test case. The reason that it was not working due to the UiPath update. When I rolled back, it was working

6

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.