Write Cell Excel Formula separator Error

Help Studio
1

Hello,
Please, is there a possibility to use formula in Write cell with dot Comma?

2

Hi @Fatima_Ourbat, welcome to the community! :tada:

Can you please elaborate your problem? What do you mean by dot comma?

3

Hello @monsieurrahul , Thanks^^
writeCell
uipath doest execute the Formula till i use commu as seperator, but for that i need to change settings in my laptop,and it’s not a portable solution

4

@Fatima_Ourbat - Did you tried escaping the comma, i.e typing twice…?

5

i want to use dot comma(:wink: instead, this the issue

6

@Fatima_Ourbat - Please share the exact formula you want to write in the write cell activity?

7 
"=RECHERCHEV(H2,OutputGCR!A:E,2,0)"

i want to write it with ; but uipath doesn’t accept

8

@Fatima_Ourbat - You mean “=RECHERCHEV(H2;OutputGCR!A:E,2,0)” - like this?

9

Yes like this “=RECHERCHEV(H2;OutputGCR!A:E;2;0)”

10

@Fatima_Ourbat - Per Microsoft, VLOOKUP formula contains , not ; right?

image

VLOOKUP function).

Refer this post, where RECHERCHEV question has been raised and the answer provided was with comma.

11

Thanks @prasath17 ,
should be always with comma!!!
but my excel app run formula with (“;”)