Append range is not working

Hi @HKF ,

If append doesn’t work for you then you can also try below approach.

Steps:
1 - Read main excel where you want to paste other excel
Get count of main data table and to + 2 accordingly if header starts from row 1
ex - lastRow = dtMain.Rows.Count + 2
2 - Use Write Range activity and pass last row to cell and also pass data table of first excel.
Similar way you can repeat this step for other excels.

1 Like