Write cell in particular condition

Help
1

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

please help

2

Hi
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
row(“Status”).ToString.Equals(“Pass”)
If true it will go to THEN part where use a assign activity like this
row(“Upload”) = “Y”
Cheers @Ananya1

3

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

in place of row can i use FilterDt

4

Cant i use Writecell

5

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

6

could u plz share workflow

7

cant it be done without for each

8

test.zip (18.7 KB)

9

thank u @Palaniyappan

10

But i got error in Assign Activity