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
864 views

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,

"=sum(C2+D2)".

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
4,084 views
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
2,472 views
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
9,137 views
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
463 views
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
2,909 views
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,109 views
+1 vote
1 answer

Move downloaded file from Outlook (UiPath)

Hey @RandomDude, I suggest you check this out https://forum.uipath.com/t/save-attached-files-from-my-outlook-in-local-folder/2218/21 Hope ...READ MORE

answered Sep 3, 2020 in RPA by Karan
• 19,620 points
321 views
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
974 views
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
1,129 views
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
1,750 views