From the below video you will be able to learn the steps to merge different input excels to different sheets of a single output excel file using the modern activities.
The same logic with minimal changes can be used for the merging of different sheets in a single excel to an output file. That video is available in the playlist too.
- Read Range
- Use Excel File
- Write Datatable to excel
Please share your feedback