Can anyone give idea how to perform an action based on the excel data

Help
1

I want to perform an action in web page using record and excel.
can anyone tell how to perform an action based on the excel data.
that web page also contains multiple folders. how to locate the folder and perform action based on the excel.
please help me

2

Can you please elaborate:

  • What kind of action do you want to perform?
  • Based on what kind of excel data do you want to perform that action?
3

excel contains pass or fail data and the unique serial numbers.
if its “pass” it will perform one action and if its “fail” it will perform another action in that webpage.

4

Use Read Range to read the Excel file and store in it a Datatable (the output variable). Then use a For Each Row loop on your datatable, containing an If activity with condition row(columnName) = “pass”. Then add the activities needed for the pass scenario in the Then block, and add the activities needed for the fail scenario in the Else block.

5

@sangeetha.b

  • Use excel application scope activity
  • Read Range activity
  • For each row activity than iterate
  • inside for each use if condition and if its pass perform action if its fail in else condition perform another action
1 Like
6

thank you !!

1 Like