Enter array formula to excel column via Blue Prism

Soniya

New Member
Hello,

I'm trying to pass Array formula to excel column for given range but unfortunately cell values in the formula are not getting updated. Whatever the formula I'm writing same is appearing in all the cell values.

Can anyone please help me to know how to extend the Array formulas to entire range so that data can get populated correctly?
 

ShubhamJangam

New Member
Hi,

Hope this will help you.

You can create code stage for it.
Input : handle, cellref,Formula
Please refer attachment for flow and code.


Thanks
 

Attachments

  • Formula Array.PNG
    Formula Array.PNG
    11.4 KB · Views: 43
  • Formula Array_2.PNG
    Formula Array_2.PNG
    2.6 KB · Views: 46

Soniya

New Member
Thanks for the response Shubham :)

I had already tried the above one but unfortunately range is not getting updated. Whatever formula I'm passing same is getting applied to all the cells.

For example, if I enter following formula to A13 cell {=+SUM(B13:E13} and once I extend the same to next cells I want cell reference to get updated as per the value i.e, for 14th cell formula should look like this{=+SUM(B14:E14}

With the above code stage for the given range same formula is getting written :(

Also after executing the code stage if I try to update the array formula manually, I do get "You can't change part of the array" pop up

1607364784887.png

Thanks and Regards,
Soniya K N
 
Last edited:
Top