Auto Fill formula in excel

[gopal_ram (gopal)]

Hello to all Genius minds out there!, I need a help with excel operation.

I have excel with many columns and from Column E to G, there are formulas that needs to be copied and pasted. I written macro but looking for Uipath code

Can you please help me on this?

[pavithra_pavi (Pavithra Bhat)]

@gopal_ram , Hi there

Have you tried “Auto Fill range”

Here is the article : Auto Fill in whole column

[gopal_ram (gopal)]

will it autofill till the end of the dataset?

[ushu (Usha kiranmai)]

Hello @gopal_ram Please check the below one

Copy Paste Range / Values / Formula / Formats in Excel | Copy Sheet | Excel Automation | UiPath |RPA

[Gokul001 (Gokul Balaji)]

Hi @gopal_ram

Welcome to UiPath community

1. Use Write Cell activity

Activities - Write Cell

2. Use Auto Fill Range activity

Check out the Video and thread

UiPath Tutorial | Uipath Auto Fill Range

Auto Fill Range Dynamically

hi, i have an excel file.it contain 3 columns. in Transaction Date Column have to fill Auto Fil based on the last row of that column. exp–C8(16-Jan-22) have to fill remain rows. [image] Can any one help ? AutoFill.xlsx (9.3 KB)

Regards
Gokul

[pavithra_pavi (Pavithra Bhat)]

To fill end of the dataset,

1. First get the number of rows in the excel. lets say “Dt1”
2. RowCount = dt1.rowscount.tostring
3. USe rowCount to define end of dataset. Example
   USe below code inside RANGE properties
   “E2:E”+ RowCount .tostring

[gopal_ram (gopal)]

Thank you @ushu

[gopal_ram (gopal)]

Thank you @Gokul001

[gopal_ram (gopal)]

Thanks!, this worked for me

[Sudharsan_Ka]

Hi @gopal_ram

You need give range like this

Checkout this sample xaml file and output
Sample.xaml (8.8 KB)
demo.xlsx (9.0 KB)

Regards
Sudharsan

[pavithra_pavi (Pavithra Bhat)]

Glad to hear!, happy to help!