How to write data from one excel file to another excel file if "Columns" of both excel files matches?

Hi, I have two excel files. Both files has same column like Name, Description, Number, material etc. I have to match the columns in both excel files e.g. input and output excel file and if column match is found, write the data of input excel file column to the output excel file column.
Thanks in Advance!


Have you tried Filter DataTable?

If not try to use the Filter datatable



Hello @Rohit_Patil1

You can refer to the below video. This can be easily done with linq expression.

1 Like

Thanks. I will try this

1 Like

Thank You Rahul! will try this

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.