Appending mutiple excel files into one excel file

Help Automation Ops
,
1

How to append mutiple files into one excel file?
How to append 10 excel files into one excel file with single headers?

1 Like
2

Hi @anjani_priya ,

Use Merge Data Table activity.

Thanks!

3

Hi @anjani_priya

You can try like this

Merging_excel_files_into_single_excel_file
Merging_excel_files_into_single_excel_file1135×2908 247 KB

Merging Multiple Excel Files.zip (42.5 KB)

Hope this helps!!

4

what is the use and purpose of taking 2 excel files activities and if else?

5

@anjani_priya

First excel is for writing the extracted data into single excel sheet and second excel is for to read input excels

6

Hi you can try this

Xaml : - Excels to datatable.zip (2.3 KB)

@anjani_priya

7

You can do this using VBA

8

Hi

Check this out the recent video on same note

Hope this helps

Cheers @anjani_priya

9

Cant we do this by using append ?
because i cant understand the assign function-isenumerable

10

yes we can use the append range activity to also instead of append i used the link query but it can possible to append also

@anjani_priya

11

Can you send the sample code?

12

I got the code but headers are not coming?How to resolve?