Auto Fill in whole column

0 votes

Hello guys,

I’m trying to automate a process in which I have a formula in the cell “E2” (simple sum of C2+D2). Now I want to apply the formula on the whole column E. I tried to read out my table and store it in a variable. Then I used the “Rows.Count” function to count to the last row which is in my table as you can see in the screenshot. When i execute the robot it says: “Excel Application Scope: Object reference not set to an instance of an object.”
Can somebody help me?

Best regards

Sep 30, 2020 in RPA by RandomDude
• 260 points

1 answer to this question.

0 votes
Hi, will tell you a method without using for each which can be used in any formula like we do drag drop in excel manually.

Use write cell. In the cell property use "E2: E".Trimend+(<your data table>. Rows.Count+1).tostring.(since your requirement starts from 2nd row here E2. IF from the first row only rows. Count)

In formula use the same,


Confirm once it worked.
answered Oct 1, 2020 by SaiPrasanth
It worked! Thank you very much :)

Related Questions In RPA

0 votes
2 answers

change a specific column of an excel sheet in UiPath

1. First of all , you need ...READ MORE

answered May 16, 2019 in RPA by Venkat
• 320 points
0 votes
1 answer

Writing multiple column in excel UiPath

You can read the entire Excel sheet ...READ MORE

answered May 9, 2018 in RPA by wrecker
• 3,110 points
0 votes
4 answers

How to find the sum of 2 columns of an excel and display it in a 3rd column using UIPATH?

These are the steps to add two ...READ MORE

answered Aug 2, 2019 in RPA by Shivi Singhal
0 votes
1 answer

Changing a specific column of an excel sheet in UiPath

You can use a For each row ...READ MORE

answered Jun 21, 2018 in RPA by Atul
• 5,550 points
0 votes
1 answer

In Blue Prism how to split excel column data into TWO columns

This is how I am doing it. Dim ...READ MORE

answered Oct 15, 2018 in RPA by Priyaj
• 58,140 points
0 votes
0 answers

HOW to extract a column data and save it in the new sheet using UIPATH

Sep 12, 2019 in RPA by anonymous
• 120 points
+1 vote
1 answer

Move downloaded file from Outlook (UiPath)

Hey @RandomDude, I suggest you check this out Hope ...READ MORE

answered Sep 3, 2020 in RPA by Karan
• 19,620 points
0 votes
1 answer

Write Cell Range does not exist in Excel

Have you tried with the workbook write ...READ MORE

answered Sep 30, 2020 in RPA by Saiprasanth
0 votes
0 answers

If condition for a popup in UiPath

Hello everybody! In a process of mine I ...READ MORE

Nov 3, 2020 in RPA by RandomDude
• 260 points
0 votes
1 answer

Identify a Column in a database in UiPath Studio

There are two options to identify a ...READ MORE

answered Feb 11, 2019 in RPA by Sahiti
• 6,380 points