How to drag a formula in the entire column in excel


#1

Hey, I have a problem, I want to drag a formula in the entire column in excel, but I don’t know how to realize that action in UiPath if someone can help me, will be a big help

Thanks.


#2

Hello,

The shortcut to “Filldown” is Ctrl+D, so if you can select the range you want the formula to drag down to, then just use TypeInto.

For example,
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.

Selecting the range will require that you know the number of rows in your table. You can use dtVar.Rows.Count to find that number, then use it inside the Range field, like
"A2:A"+(dtVar.Rows.Count+1).ToString

Hope that gets you in the right direction.


#3

Well, I only have problem with the range, thanks Clayton