Write Cell Range does not exist

Help Activities
, ,
1

Hello everyone, I hope you are doing well.

I have a specific problem with the “Write Cell” activity (screenshot). I want to apply the formula “=CONCATENATE(AM2;AN2;BE2)” for the whole column but when I run the robot it says “Range does not exist”. However, when I leave the range as it is but change the formula to something simple like “=1+2” it works. On the other hand when I put in the initial formula by myself (not by the robot) into the excel file it works too. That is why I wonder that the robot doesn’t do it correctly. Any ideas how I can solve this issue?

Best regards

Range does not exist
Range does not exist1915×834 64.3 KB

1 Like
2

Unless it has changed recently, I believe you need to supply a single cell rather than a range of cells (I rarely use the write cell activity and usually use write range instead, so this may not be true anymore)

3

HI @RandomGuy,

you need to do something like this
image

Use autofill range to drag formula to the last

Cheers

4

I wrote in the cell I need ("BG2) and it still says Range does not exist

5

I did and it still says range does not exist :confused:

6

Can you share xaml and the file so that a solution can be provided

1 Like
7

I changed the original file because there are some private data but there is the same problem :sweat_smile:

Concatenate.xaml (5.0 KB) Error.xlsx (10.8 KB)

8

Hi @RandomGuy,

Error.xlsx (11.2 KB)
Concatenate.xaml (4.9 KB)

Please have a look, i made some changes and this code is working in my system

9

Well… :sweat_smile:

image
image1598×721 53.3 KB

10

Hi @RandomGuy,

Just delete the project.json and open the file again + update the packages in Manage Packages.

11

I did it all and it still shows the same. Can you maybe take some screenshots of the code and properties?

12

just in the concate.xaml you provided replace your formula in write cell their and instead of semicolon put comma , something like

“=CONCATENATE(AM2,AN2,BE2)” and try

13

I changed the formula to the way you told me with the commas and I get a new Error “Write Cell: Exception from HRESULT: 0x800AC472”

image
image2012×734 122 KB

14

Before Excel Application scope put a kill process activity in that in process name enter “excel” and in scope before writing to cell give a delay of 2seconds

15

I put again the simple formula “=1+2” into write cell and even that won’t work. The same error appears. Now I added the activities you told to add and it seems that I got into an endless loop because the process is already running 5 minutes :thinking:

image
image1877×903 74.9 KB

16

Their is some issue in your excel file dude that is not letting write cell perform the operation , if you can share the Xlsx file i can have a look for what is wrong.

17

Ok I fixed the exception thing and changed the concatenate formula and added the commas. It runs but when I look at the excel file I just see “#NAME?” and the formula in excel says “=@CONCATENATE(AM2,AN2,BE2)”. Now I wonder where the “@” comes from :smiley: