I have a sample xaml file which I had created few days back to assist one of my friends here in the forum. I think it should help you as well. This basically takes data from two excel files and merge’s them together and writes back to another excel.
I guess this is what you are looking for. Depending on your scenario, you can try changing it to get it optimized as you require. For example, if you have all the excel files that you need to read in one particular folder, you can get the files from the folder and loop through them.
Merge two excel files
mergeTwoExcelSheets.xaml (6.5 KB)
In case you need to get multiple files from one single folder and merge them all, refer this.
merge datatable.xaml (9.8 KB)
Hope it helps
Anil_G
ashokkarale
jinal.shah
Gautham_Pattabiraman
postwick
chandreshsinh.jadeja
vrdabberu
Ajay_Mishra
sven.wullum1
Vyshnavi_Nalumachu