Merge 2 different Excel In 1st excel

Help Studio
, ,
2

hello @HELZMOTH_BJ ,

Firstly, you need to find last row of excel 1 by using - dt.rowcount
then you need to use write range in excel 1 with datatable of excel 2 and give range - “A”+(dt.rowcount+1).tostring

This image shows a sequence of actions within an automation workflow to read data from two Excel workbooks and write the combined data to another Excel file. (Captioned by AI)
This image shows a sequence of actions within an automation workflow to read data from two Excel workbooks and write the combined data to another Excel file. (Captioned by AI)543×416 14.6 KB

let me know if this works.

Cheers!