Combine result of two excel

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

Hi

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?

BR, MMC

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.

Combine_Result_of_Two_Excel.zip (18.8 KB)

BR, MMC