Excel Automation in

Help Studio
, , ,
1

Get all the files from a folder and merge them into a single file and write the final merged file. How to do this describe the workflow ?

2

Hi @ankit.dutt

  1. you can use for each activity to loop through each file.

  2. if the file is excel you can use read range activity to read the file.

  3. you can use append range activity to merge files to data.

image

hope it helps!!!

1 Like
3

Hi @ankit.dutt

Insert all the input excel files in the Input Folder.
Change the folder paths in the argument panel.

Append Excels.zip (342.1 KB)

Hope it helps!!

1 Like
4

Thank you so much brother

5

Hi @ankit.dutt

please mark this is as solution, if your problem resolved.

Happy Automation. cheers.

1 Like
6

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.