Use a configuration file

I have data on an excel file and I wanted to read each line, and the corresponding value if it is good he will click on the corresponding option. how i could do that
Capture

Hi!

We can do like this:

1.Excel Application scope-File Path
2.Read Range from excel -SheetName-Output as Dt.
3.Take one for each row in data table and pass the Dt.
4.Take 2 assign activities.->Create a string variable as Nom=CurrentRow(“Column1Name”).ToString.
5.Create one more string variable as Valueur=CurrentRow(“Column2Name”).ToString.
6.Take one if condition (Nom=Valueur)
7. Then: click

Regards,
NaNi

Hi,
Thanks for y’re answer !!

1 Like

HI @sarra.meziane1

Use Workbook Read range activity

Store the value output in DT

Use For each row in data Table

If condition

Refer to the screenshot

Here is the Workflow Skeleton
Sequence1.xaml (8.1 KB)

Regards
Gokul