How to merge multiple excel files into a new file

Help
1

i have all my three excel files in single folder and now i have to merge all together in a new excel file can anyone suggest me how to do it?

1 Like
2

@kaavya

Is the Schema of all three Excel sheets are Same.?

Regards,
Mahesh

3

If all of your files have the same columns, you can do the following:

  1. Get list of all files in your folder
  2. For Each loop on your result from 1
  3. Read range on workbook
  4. Use the Merge Datatable activity to append each Datatable to a master Datatable
4

yeah.

5

Hi @kaavya

You can also try to use this component. This has a template that supports your need

https://go.uipath.com/component/merge-content-of-multiple-excel-files

1 Like
6

thank you

1 Like
7

Is Merge Datatable a standard activity or do I need a special package? Do you know the name of that package?

8

Data is all sitting in column A, but has a slightly different number of rows.

9

what if they have different schema?