Use a configuration file

Help Studio
, ,
#1

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

#2

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

#3

Hi,
Thanks for y’re answer !!

1 Like
#4

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

image
image828Ă—730 21.8 KB

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

Regards
Gokul