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 in RPA by RandomDude
• 240 points
86 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 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
3,564 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,243 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
6,757 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,540 points
359 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
• 57,700 points
2,531 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
717 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 in RPA by Karan
• 18,640 points
79 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 in RPA by Saiprasanth
124 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,320 points
1,343 views
0 votes
1 answer

Which edition of UiPath is more suitable for individual use, Enterprise Platform or Community Edition? Why?

UiPath’s Community Edition (CE) is the version which is ...READ MORE

answered Mar 7, 2019 in RPA by Mishti
• 480 points
799 views