How to use drag activity in uipath?

Help
,
1

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
2

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
3

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

1 Like
4

@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
5

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

1 Like
6

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
7

image
image478×624 12.4 KB

1 Like
8

Thanks, it’s working

1 Like
9

Thanks a lot