Click Based on excel data

Help Studio
1

i have one excel sheet which contain ID and Condition. In condition there is total 3 case: READY, CLEAN and DIRTY. based on id and condition which is already write in excel robot click on that particular condition like if in excel there is DIRTY at 103 than robot click on web at 103 id name row to DIRTY.

2

Hi @Rutva_Patel

  1. Read the Excel file and store the Output in a variable Called DT
  2. Use For Each Row in DataTable
  3. Use If condition
    CurrentRow(“Column Name”).ToString.Contains(“DIRTY”)
    Then → It will click the Web at 103
    Else → Use If Condition
    CurrentRow(“Column Name”).ToString.Contains(“Ready”)
    Then → It will click in the Web
    Else → Use If Condition
    CurrentRow(“Column Name”).ToString.Contains(“Clean”)
    Then → It will click in the Web
    Else → Stop the process

Refer the Screenshot

image
image1174×718 26.5 KB

Regards
Gokul

3

thanks for your reply… I want click based on ID suppose in excel there is ID:101 and Condition: READY. so based on this i want click on REDAY button at 101 ID.

4

If you have only 3 condition better to apply switch condition.

5

Hi @Rutva_Patel

CurrentRow(“ID”).ToString.Contains(“101”) Then Click “Ready in the Web”

Reagrads
Gokul

6

aa
i have this type of data

7

based on room i want click on any one CLEAN, DIRTY and READY

8

@Rutva_Patel

Use the selector and open in UiExplorer

Check the tag which has CLEAN / DIRTY / READY

Enable that, Now in For Each activity you can assign as variable as Condition = CurrentRow(“Condition”).ToString

This variable pass to the selector, so this will make dynamic

Hope this may help you

Thanks

9

Hi @Rutva_Patel

You can find the Steps with Screenshot

Regards
Gokul