Hi,
1)use read range activity so all the data from the excel will be available in Datatable.
2)Use for each row for processing row by row
3)inside the for each row activity, give assign to write the status.(if status pass—> In assign activity row.item(“status”)=“Pass”.
4)this will add the status to the Datatable.
5)once all the rows are completed, use write range activity to write everything in a new excel sheet