How to compare two excel files and update
Please find below link for your reference
For example: i want to add pincode column in first excel based on the second excel file, here the common column for both excel files are city column
You can use join function for this.
Got your point u can use lookupdatatable
Please watch this link
Definitely u will achieve on your own if not please let me know
But the city column in the second excel is sorted one based on that rows i have to match and update pincode, in real project I had more columns other than pincode in second excel
Read both into datatables. Compare and manipulate the data in the datatables. Write back to Excel from the datatables.
thanks for help
@Sreekar_Mulinti happy automation
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.