How to merge two excels into single excel

Help Activities
, ,
1

I want to merge both excels into single please help me to do this
RPAMMCHG49InvalidRejected.xlsx (8.9 KB)
RPAMMCHG46InvalidRejected.xlsx (10.6 KB)

1 Like
2

HI @HeartCatcher

You can try with Merge data table activity

Check out the XAML file

MergeDT.xaml (7.1 KB)

Regards
Gokul

3

HI @HeartCatcher

Check out the XAML file

  1. Use Read range activity → Store it as Dt1

image
image887×226 12.8 KB

  1. Use Read range activity → Store it as Dt2

image
image893×133 5.1 KB

  1. Use Merge data Table activity

  2. Use Write Range activity

image

Regards
Gokul

4

@HeartCatcher

image
image450×596 14.5 KB

This is working!

5

@HeartCatcher please ensure not to forget to put right sheet name and range as shown.

6

Actually at end of the process the output file will generated it can 2 excels or more it is not constant so how can I merge the excels irrespective of the number of excels

7

HI @HeartCatcher

Check out this video link

Regards
Gokul

8

@HeartCatcher

image
image677×506 12.5 KB

We can simply use the activity and perform similar operation .It will work irrespective of number of files getting generated!