Loons
August 5, 2020, 2:15pm
1
Hello there,
I want to insert a specific formula into an excel cell but I always get the same error:
If I try it with an easier formula everything works. If I copy the formula into an excel sheet it also works perfectly. So, what’s the problem?
That’s my code:
Nithin_P
(Nithin Prabhu)
August 5, 2020, 2:20pm
2
Hello @Loons ,
What is the formula you want to write to the cell ? Could you please post that here ?
Regards,
Nithin
Loons
August 5, 2020, 2:23pm
3
=SUMIFS(D6:AH6; D3:AH3; “=7”)
that’s an example…
later on I would like to use a counter instead of the rows for the sum
E.g: “D” + counter.toString + “:AH” + counter.tostring
Nithin_P
(Nithin Prabhu)
August 5, 2020, 2:49pm
4
I think the formula is =SUMIFS(D6:AH6,D3:AH3,"7")
. Hence in UiPath I recommend you place the formula in a text file =SUMIFS(D<C2>:AH<C2>,D<C1>:AH<C1>,"7")
, then read the file & do a .Replace("<C2>", YourCounter).Replace("<C1>", YourCounterVariable)
, then use the resulting string to write to cell.
Hope that helps ! Kudos
Regards,
Nithin
4 Likes
system
(system)
Closed
August 8, 2020, 2:49pm
5
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.