Write cell in particular condition

There would be multiple rows in excel
i want to update"Y" in column upload only when
if status is “Pass”
Download is “Y”Capture1434

please help

Hope these steps would help you resolve this
—use a excel application scope and pasUploads the file path as input
—inside the scope use a READ RANGE and get the output with a variable of type datatable named dt
—Then use a for each row activity and pass the input as dt
—inside the loop use a IF condition like this
If true it will go to THEN part where use a assign activity like this
row(“Upload”) = “Y”
Cheers @Ananya1

Actually i have filtered row in that excel sheet so i have used Filter Wizard

in place of row can i use FilterDt

Cant i use Writecell

That doesn’t matter even if the excel is applied with filter we can ignore that
Which is possible when the property USE FILTER is disabled in the READ RANGE ACTIVITY
and ya of course we can use write cell activity inside the if activity Inside for each row loop
Where the value is “Y” and cell is “C”+(dt.Rows.I dexOf(row)+1).ToString

This can be used instead of assign activity
Cheers @Ananya1

could u plz share workflow

cant it be done without for each

test.zip (18.7 KB)

thank u @Palaniyappan