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
How to read three sheets in an excel
Merge multiple excel sheets into single excel sheet (with multiple spreadsheets)
@skrishna, there are two approaches,
Merge Datatable - Read 3 Excel sheets and save to datatable variable dt1,dt2,dt3 and use merge datatable activity to merge this 3 datatable.
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.
Append range is working …Thanks for the solution
Hi, is it possible to share your solution?