Sample Input Excel file
|Test Project 1
|Test Project 2
Above excel data will be added to queue or we will read data directly from excel and our bot will search the each project in the portal .
if the value of the cost in the excel is 80 or below then it has to select the Cost in 1.2 deficiency element OR if the value is above 80 then bot has to select NA.
and repeat the steps for remaining deficiency elements as per the excel.
May I know the logic to complete this task?
Use Read Range activity to Read the Excel and declare a variable in the properties to make data to Datatable, Let’s say the variable is Dt
Now use For Each Row activity and pass the variable which is Dt
Use IF condition inside For Each Row activity write condition as
Cint(row(“Cost”).ToString) > 80
Then-> Place Select Item activity, and write as “Cost”, If you are getting error then you have to keep click activity to click the dropdown and any click activity to click on Cost
Else->Place Select Item activity, and write as “NA”, If you are getting error then you have to keep click activity to click the dropdown and any click activity to click on NA
Repeat the same for others also, but it should be inside the For Each row
Hope this will help you
This can be achieved with a if condition
Hope the below steps would help you resolve this
Let’s take you have the value in queue or excel and retrieved the COST column value alone in a string variable named Strinput
Now use a IF condition and mention the condition like this
Convert.ToInt32(Strinput.ToString.Trim) <= 80
If true it goes to THEN block then select that 1.2 deficiency element with a click activity and use select item to choose any value from drop down
Or goes to ELSE block where use select item to choose the NA value from you want
if select item does word use a normal click activity two times where first click on that drop down and second choose the value
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.