Merge excel sheets into an excel


i am unable to merge the excel sheets of an excel to another excel
problem: I have three excel sheets Inclusion,Termination,Revised sum assured in a excel .
i am trying to merge all the data into an excel but the result is overwriting .please find the attachments and suggest me a solution

Thanks in advanceFinal_day.xaml (15.0 KB)
result.xlsx (8.0 KB)
GTL Movement Form_02.01.18.xlsx (43.4 KB)

How to read three sheets in an excel
Merge multiple excel sheets into single excel sheet (with multiple spreadsheets)

@skrishna, there are two approaches,

  1. Merge Datatable - Read 3 Excel sheets and save to datatable variable dt1,dt2,dt3 and use merge datatable activity to merge this 3 datatable.

  2. Append Range - Read 1 sheet store to dr and append to another Excel using append range dt and do the same for rest of the sheets.

Dominic :slight_smile:


Append range is working …Thanks for the solution :grinning::+1:


Hi, is it possible to share your solution?