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.
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
Thank you Hareesh
let me check with this.