How to consolidate excel files with different sheet names and merge in a single file

How to consolidate excel files with different sheet names and merge in a single file
test1.xls (23 KB)
test1.xls (23 KB)

Thanks
Ashwin S

1 Like

It has another file as test 2 with sheet name as UM2

Thanks
Ashwin S

Buddy @AshwinS2
will those be same excel file with different sheets or different excel files with sheets in them
Cheers

Hi @Palani

I DO HAVE DIFFERENT EXCEL FILES AS TEST1.XLS WITH SHEET NAME AS UM1 AND TEST2.XLS WITH UM2 SHEET NAME I WANT TO MERGE THAT INTO SINGLE FILE

THANKS
ASHWIN S

Hi @AshwinS2

I have created workflow based on your requirement here I used your attached two excel files.
1.First excel file(test1.xls) sheet name UM1.
2.Second excel file(test2.xls) sheet name UM1
3.Finally I merged above two files and save to Output.xls file

MergeTwoExcelFiles.zip (20.0 KB)
.

1 Like

Thanks for the post

Thanks
Ashwin.S

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