How to apply the below formula to the entire column

[bhanu.priya2 (Bhanu Priya)]

Hi Team,

Kindly find the below screenshot FYR

How do i apply the above formula to the entire column

[fernando_zuluaga]

hi,

kindly check this post

How to drag a formula in the entire column in excel

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”+(d…

Regards

[bhanu.priya2 (Bhanu Priya)]

Hi Thanks for your reply but type into is not giving proper solution please find the below screenshot FYR, it is just copying the same to entire Colum

[Rahul_Unnikrishnan]

Hello @bhanu.priya2 ,

You can use Fill Range activity to achieve the same. Check the below doc.

Fill Range

[jack.chan]

download this custom activity and use drag formulas activity

Excel Activities for Processing and Filtering - RPA Component | UiPath...

[Kia1 (Ana)]

Please help,

I have an Excel file “Excel Template” that I want to fill out

1. Column A8 : C1000 will be filled with data from CSV that I have in the CSV folder
2. Columns E1:K10 will be filled with images that I have in the Image folder
3. Column E12 : K20 will be filled with a circle pivot graph obtained from the data in column A8:C100

Once finished it will be saved in a folder and given a name according to Excel “ListAccount” in the “Subaccount” column

The “Excel Template” file will loop according to the data in the “LisAccount” file

How to create a project like the flow above, so that the “Excel Template” file can run well?
ListAccount.xlsx (9.3 KB)
Excel Template.xlsx (10.3 KB)