Passing values in a paritcular cell in excel


I having attached a excel. In that excel I at the right side corner under “Robot Status” header for each rows I have to Pass either “Passed” or “Failed” as status. How can i achieve it.

Sequence.xaml (14.7 KB)

Name5.xlsx (21.2 KB)

1 Like

First we can get the datatable from the excel with read range activity and store that in dt
—now use a for each row activity and pass the above variable as input
—inside the loop use a if condition and set the condition if any we want
If it passes it will go to then part where use a WRITE CELL ACTIVITY and mention the value we want and cell range as Dt.Rows.IndexOf(row)+2

Cheers @monish06

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.