If your Excel sheets has fixed columns and rows (like your example), then maybe start by:
- Using Excel Scope
- Reading the ranges from Excel 1 and 2 (save them in datatables)
- Use Write Range activity to write Excel 1 datatable in the Result Excel
- Then use the Append Range to append the datatable from Excel 2 into Result starting in cell “D1”
Hope this can help you on your way?
Could you please provide one sample example for above.
I have uploaded a sample for you, but it is quite limited to the Excel-files provided.
Combine_Result_of_Two_Excel.zip (18.8 KB)