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