What is the fastest way to copy data from an excel sheet to another one?

[kit2815]

Hi Everyone!

I am having 2 datatables now: dtResult4 and dtResult5.

dtResult4 includes a huge number of row items but I only want to copy some of the columns in dtResult4 to a new blank excel sheet called dtResult5.

Could anyone share the fastest method with a demonstration?
Either like Assign Activity or For each row?

Many thanks.

[kit2815]

Could anyone please help me?

I am now using the assign function under for each row activity in dtResult5.

Let Row.item(“Staff ID”) = dtResult4.rows.item(“Staff ID”).ToString

However, it is not working. May I know where is the problem please?

[Sergey_Petrenko]

Hi,

please, try using Add Data Row activity)

https://docs.uipath.com/activities/docs/add-data-row

[MaciejM (Maciej)]

Hi!

Try with Filter Data Table activity. In filter configuration set output columns.

[kit2815]

Thanks, both. I will try both methods and see which is the better solution for me.