Hello, I want to concatenate a number of 15-20 excel files and I need to keep the headers just for the first excel and the other ones to be appended from the bottom without the headers.
How can I do this?
Use write range for the first file and for all others use append range activity
Or
Alternately…read each file and use merge datatable activity to merge the data and write using write range for once
Hope this helps
Cheers
Hi @adrianab.98
Use a read range to read the first excel, make sure the option add headers is enabled, then follow this example
Main.xaml (12.9 KB)
make sure to replace all the corresponding values
Regards
I can’t open the file. “Document is invalid” I tried to open in multiple ways but failed
Try again with this
ForumW (2).zip (10.4 KB)