How to Concat formula in "write cell" activity?

Hello everyone!
I need to join dynamic alphabets while using excel formula using “write cell” activity.
for example : =RIGHT(Z2,6) , This is my formula and “Z” will be dynamic in process . I have attached picture or my code. but it’s output is different for which I’m getting error


ERROR is here

Try below ode



activity is not accepting + operator . To concatenate & is is only accepted

not worked!

None of them is working?

yes none of this is working

if you can share the xaml, it will be great

I found the solution for it.

Trim(“=RIGHT(”+iBankRfNo.ToString()+“2,6)”).ToString.Replace(Environment.newLine, “”)

1 Like