How to Merge Two Excel Files Into a Single Excel File?

[robert_singval]

hi
i have two excel files …
How to Merge Two Excel Files Into a Single Excel File? help out of these…

[Gokul001 (Gokul Balaji)]

HI @robert_singval

You can try with merge Datatable activity

[Shiva_Nikhil]

@robert_singval

use read range activities for reading two excel files

use merge datatable activity to merge the data

below use write range activity to write to excel

[Gokul001 (Gokul Balaji)]

1. Read the 2 excel files → Store the values in Dt1 and Dt2
2. Use Merge datatable activity

Source - Dt1
Destination - Dt2

3. Use Write range activity

@robert_singval

[Palaniyappan (Forum Leader)]

Check this out

Merge Multiple Excels to Single Excel using UiPath | Input sheets to separate sheets in output Excel

Cheers @robert_singval

[K.Nithin_Kumar]

@robert_singval

1. Read Excel Data use read range activity (Dt_1) and Read Range (Dt_2)

2.Use the “Merge Data Table” activity to merge the data from the two DataTables into oneUse.

3.Use the “Write Range” activity to write the merged data to a new Excel file.(Merged Data)

[sai_gupta]

hi

@robert_singval i hope this helps to you

1.Drag and drop the two ‘Read range’ activities
2. Select the location of the Excel file to read
3.Repeat with another Read range action and a different Excel file location.
4.Select an Assign activity
5.create a variable called mergedfile. Change the type of the variable from generic to the system.Data.DataTable
6.read range excel_file1.Clone().
The clone function duplicates the structure of an existing data table. However, the data is not copied.
7. two different merge data table actions by dragging and dropping them.
8.Each merging data table’s destination and source must be entered separately.
9.Drag and drop a write range to be written.

cheers…!