For Each in Folder with Excel Copy Paste Range

Learn
#1

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

#2

Hi,

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

img20200615-3
img20200615-3734×871 19.4 KB

Regards,

#3

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.