Write Excel formul using Write Cell Activity

Hello Everyone,

I want to write a formul into excel using the write cell activity, but I am getting an error in this way. I want to write directly, not with Read Range / Write Range activities. Is there a way to this?

image
image

Thank you!

@korhansuren you can keep the formula in text file and then read text file keep that variable in write cell it works :slight_smile:

1 Like

Hi @korhansuren ,

Write the formula like below and try. thanks.

“=TEXT(G1;”+CHR(34)+“gg.aa.yyyy”+CHR(34)+")"

When I tried the formula you wrote, I got an error like this.

image

instead of semi colon use comma in the formula i guess. please try and let us know.

“=TEXT(G1,”+CHR(34)+“gg.aa.yyyy”+CHR(34)+")"

Could you check your formula whether you are manually entering excel is working and also use one log message and put the above expression and see if it is printing the formula your using is correct. thanks.

I think the problem is caused by region/language settings. I get the same error when I try to write with “,” . I’m from Turkey. in TR form “;” it is used but i think it supports as UiPath “,”

ok. Not sure on these regional settings. If we want to add double quote in the expression we can use CHR(34) so that in run time it will replace with the double quotes. nice connecting with you. thanks.

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.