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

Oct 1, 2020 in RPA by RandomDude
• 260 points
3,132 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
5,483 views
0 votes
1 answer

Writing multiple column in excel UiPath

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

answered May 10, 2018 in RPA by wrecker
• 3,110 points
3,228 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
13,887 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 22, 2018 in RPA by ffdfd
• 5,550 points
905 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,090 points
4,063 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
2,091 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,610 points
1,673 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
3,306 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
4,928 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 12, 2019 in RPA by Sahiti
• 6,370 points
2,498 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP