After comparing of two excel sheets replace excel data if the two excel sheet data are same

Hi,
Here i have an issue regarding excel automation . I have question That should compare two excel sheets replace excel data if the two excel sheet data are same.

Hi Padma

you can go through this link. Comparing two excel sheets and make it into new excel file

Hi Harish ,
Yes,what you said is good with that information i can only compare the two excel sheets.but now what iam asking is for replace the data in to an excel sheet when only the two excel sheets data are same.

We have lot of topics available for the same @KiranPadma

If you are comparing using the for each row activity, you will get the index of whatever row you are comparing, then simply use write cell activity to replace it whatever text

https://forum.uipath.com/search?expanded=true&q=compare%20two%20excel%20%20status:closed

Thank you Hareesh
let me check with this.