Unable to insert a new data using write a cell in new excel comparing with other excel data

[anilkumar.vegi]

hi Team,

i am comparing the old excel sheet if i found mismatch the record then i need to write a whole record into new excel sheet. but i am failing to write.

[Srini84 (Srinivas Kadamati)]

@anilkumar.vegi

Check below post

Comparing 2 excel files by column and store the mismatch data row in next tab

Hi All, I have 2 excel files, test1 and test2. I am comparing test1.xls with test2.xls using first Column. I need to write the unmatched data in second tab of test1.xls. test1,xls - [image] test2.xls- [image] Output in sheet2 of test1.xls - [image] Attached is the xls file too. test1.xlsx (9.9 KB) test2.xlsx (8.6 KB) Any help or xaml would be really helpful.

Mark as solution if this helps

Thanks