when i run robot i have to match two columns in excel at run time
for ex : columns name
NAME CITY SEARC NAME
ABC XYZ ABC MATCH
PQR TYZ DEF NOT MATCH NAME
RST MNP RST MATCH
Should be such a WRITE in excel
how can do this?
Try below steps.
Use Excel Read Range activity to read the data from Excel file and it will give output as DataTable. Let’s say dtInput.
And then use For Each Row to iterate one by one row from DataTable.
For Each currentRow in dtInput If currentRow("NAME").ToString.Trim.Equals(currentRow("SEARCH").ToString.Trim) Then currentRow("ColumnName") = "MATCH" else currentRow("ColumnName") = "Not MATCH"
Finally use Write Range activity and pass DataTable dtInput to write into the excel file.
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.