How to replace a data from specific columns to specific

Help Studio
, ,
3

Steps to Replace “Yes” with “Pending” in Specific Columns:

Read the Excel file using the “Read Range” activity (Store in dtData).
Loop through each row using “For Each Row” activity.
Modify values in specific columns (Column3 to Column5).
If row(“Column3”).ToString.Trim.ToLower = “yes” Then
row(“Column3”) = “Pending”
End If

If row(“Column4”).ToString.Trim.ToLower = “yes” Then
row(“Column4”) = “Pending”
End If

If row(“Column5”).ToString.Trim.ToLower = “yes” Then
row(“Column5”) = “Pending”
End If
Write back to Excel using “Write Range”.