I need to merge more than 100 excel files

Help Studio
, ,
1

Good morning

How could you merge excel files? I am talking about approximately more than 100 excel files that must be joined or merged into a single file, and later uploaded to google sheet.

Excel files have the same format of fields, columns, etc.

2

@Julian_Yamid_Torres_Torr1

Welcome to the community

  1. Use for each file in folder activity with filter on .xlsx
  2. Inside the loop use read ramge workbook and read the data into datatable
  3. Use if condition to check if this is the first iteration currentindex=0
  4. On then side use finaldt = dt.Clone and then finaldt = dt.CopyDataTable
  5. Else side use merge datatable and merge dt with finaldt
  6. Outside loop use write range and write the finaldt to new excel

Cheers

3

Hi,

Hope the following sample helps you.

image
image967×2448 158 KB

Sample20230531-3.zip (15.3 KB)

Regards,

1 Like