I want to merge the 2 unstructure excel files?

[Kanak_Lata_Singh]

Hi @Naveen_Kanike

Naveen , you can try converting / reading the data as Datatable , then merge datatable together , add custom column names and then write them in an output excel sheet .

For reference please refer

How can we extract data from Unstructured excel

How can we extract data from Unstructured excel.

Merging of datatables

Hi, I have 5 excel files in a folder and want to merge data tables. I used “For each file in the folder” activity to pass the files and I used “Excel application scope” to read the “sheets” by using “Get Workbook Sheets” and a “Read Range” activity. Now How can I merge the data tables from the files in the folder. How can I use 2nd “Read Range” activity to read other file to merge as “merge datatable” requires atleast 2 data tables. Regards,