For Each in Folder with Excel Copy Paste Range

I have a process where I want to merge multiple excel files into one file. All the files have the same data but saved by city name in one folder. Do I use the Copy Paste Range and/or the Append Range? I want to use a For each in Folder to get each file. Can anyone help


I suppose perhaps you should use MergeDataTable activity as the following.


If you want to merge them into a single sheet, then you’d want “Append Range”. “Copy and Paste Range” will overwrite the data where append will automatically place it at the end.