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

Help Robot
,
1

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!

2

Hi!

Have you tried Filter DataTable?

If not try to use the Filter datatable

Reference:

https://docs.uipath.com/activities/docs/filter-data-table

Regards,
NaNi

3

Hello @Rohit_Patil1

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

1 Like
4

Thanks. I will try this

1 Like
5

Thank You Rahul! will try this

6

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