How to use drag activity in uipath?

Dear All,
I am working on excel automation. How can I use the ctrl+d command for all the remaining cells in excel with write cell activity?
image

1 Like

Hey @Rakesh_Yadav,

You need to use a for-each loop.

Or you need to read, manipulate in the datatable & then write back.

Thanks :slight_smile:

2 Likes

Thanks for your replay. do you have any other idea to use ctrl+d function?

1 Like

@Rakesh_Yadav

you can use Write Cell "formula"
Select Range
TypeInto "[d(ctrl)]d[u(ctrl)]"

β€˜d’ for down and β€˜u’ for up to simulate the hotkey. (You might be able to use Send Hotkey too.

1 Like

Thanks @manish.patel
I tried but it is not working, can you explain with screenshot?

1 Like

Hey @Rakesh_Yadav,

Try this out.

This should fulfil your need.

ExcelWriteCell.zip (7.9 KB)

Any query let me know

Thanks :slight_smile:

1 Like

1 Like

Thanks, it’s working

1 Like

Thanks a lot