Merge excel sheets into an excel


#1

Hi,
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)
#2

@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.

Regards,
Dominic :slight_smile:


#3

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


#4

Hi, is it possible to share your solution?