Combine result of two excel

I want to combine the result of two excel into one then how should i do.
Excel 1.xlsx (8.1 KB)
Excel 2.xlsx (8.1 KB)
Result.xlsx (8.2 KB)


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?


Hi mmc,
Could you please provide one sample example for above.

Hi Rup

I have uploaded a sample for you, but it is quite limited to the Excel-files provided. (18.8 KB)