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?

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

@gopal_ram , Hi there Have you tried “Auto Fill range” Here is the article : Auto Fill in whole column

will it autofill till the end of the dataset?

Hello @gopal_ram Please check the below one [Copy Paste Range / Values / Formula / Formats in Excel | Copy Sheet | Excel Automation | UiPath |RPA]

Hi @gopal_ram Welcome to UiPath community Use Write Cell activity Activities - Write Cell The UiPath Documentation Portal - the home of all our valuable information. Find here everything you need to guide you in your automation journey in the UiPath ecosystem, from complex installat…

Hi @gopal_ram You need give range like this [image] Checkout this sample xaml file and output Sample.xaml (8.8 KB) demo.xlsx (9.0 KB) Regards Sudharsan

Glad to hear!, happy to help! :smiling_face:

Auto Fill formula in excel

Help Studio

Gokul001 (Gokul Balaji) October 11, 2022, 7:11am 5

Hi @gopal_ram

Welcome to UiPath community

Use Write Cell activity

Use Auto Fill Range activity

Check out the Video and thread

Regards
Gokul

Topic		Replies	Views
Copying formula from excel cell A2:O2 and pasting till end of the sheet Studio studio , question , project_panel	13	805	April 3, 2023
Data filling in excel column without for each loop Help	2	2067	February 28, 2019
Auto Fill Range Dynamically Studio	6	3670	May 27, 2022
How to copy one cell data into different rows of same cell using UI path Activities excel , studio	3	442	January 25, 2023
EXCEL Write Cell / Auto Fill Studio	13	2336	April 14, 2021

Auto Fill formula in excel

Related topics