Write Cell Range does not exist in Excel

0 votes

Hello guys!

I want to add a formula (Subtotal) in my excel file using UiPath with the Write Cell activity. I have a column going from C1 to C7 and the data start at C2. I want to put the formula to C8 but the Write Cell activity doesn’t accept the range I declare in the formula. You can see it in the screenshot. Do you have a solution?

Best greetings!

Sep 30, 2020 in RPA by RandomDude
• 260 points
3,778 views

1 answer to this question.

0 votes
Have you tried with the workbook write range?

Sometimes excel scope finds it hard to find the ranges. Try with the workbook write range and confirm if it worked.

Check with the formula as well, if the formula is wrong then the same error occurs.
answered Sep 30, 2020 by Saiprasanth
Not yet. I did it now by using the Click activity and then type into. It is not very elegant but it works. Another solution would be better though
Using the "write cell" activity, you can write the formula in your first cell which is C2, and then use the "autofill range" activity to fill this formula from range C2 to C8.

To write a formula in one go, you can try the "write range" activity as well which will take Excel range and datatable as input.
I did it by writing the following in the range: ""E2: E".TrimEnd+(dataTable.Rows.Count+1).ToString"

Somehow it worked :D

Related Questions In RPA

0 votes
1 answer

how get the specific data from an excel and write in another excel file in uipath?

@Renuka, I agree with your approach. You ...READ MORE

answered Aug 19, 2019 in RPA by Abha
• 28,140 points
4,512 views
0 votes
1 answer

RPA : How to extract specific data from scanned pdf and write into excel in blueprism?

Your query is similar to https://www.edureka.co/community/6509 ...READ MORE

answered Mar 23, 2020 in RPA by Sirajul
• 59,230 points
2,257 views
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,852 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,462 views
0 votes
4 answers

Pivot table in excel using UIpath

You can use Create Pivot Table activity ...READ MORE

answered Feb 26, 2019 in RPA by Anvi
• 14,150 points
5,363 views
0 votes
1 answer

What is an Orchestrator in UiPath

Hi Ashmita, Orchestrator is a UiPath product that enables ...READ MORE

answered Mar 6, 2019 in RPA by Abha
• 28,140 points
2,755 views
+2 votes
1 answer

How can I connect Robots to Orchestrator in UiPath?

Hey Rakshit, for connecting Robots to Orchestrator, ...READ MORE

answered Mar 12, 2019 in RPA by Abha
• 28,140 points
21,168 views
0 votes
1 answer

What are the types of robots you can create in an Orchestrator in UiPath?

Hi Urvashi, there are 2 types of ...READ MORE

answered Mar 12, 2019 in RPA by Abha
• 28,140 points
10,767 views
0 votes
1 answer
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