Fill cells into Excel did not execute formula

[abdel (Robot usa)]

Hello friends,

when I’m executing a uipath script i’m filling an excel file with 2 amount (strings):str1=“-65233,34”; str2 = “-65343,5”

and there is a column which is the sum of the two values.

but this sum shows #values

any suggestions ?

[manjula_rajendran]

Hi @abdel ,

I think you are filling with string values. Covert the string to integer

[abdel (Robot usa)]

it does not work:

error: string format incorrect

[manjula_rajendran]

@abdel

“-65233,34”

Is it “,” between numbers? -65233,34

[manjula_rajendran]

To conver to integer your have to use like

CInt(yourstring)

[abdel (Robot usa)]

yes it’s “,”

[manjula_rajendran]

I’m not sure how you sum this
-65233,34
-65343,5

What is the sum you are expecting.

Sample please

[abdel (Robot usa)]

sorry it s the difference

[abdel (Robot usa)]

how to fill integer into excel ?

[manjula_rajendran]

When you are writing into excel cover the value to inetger

val = “-65233,34”

IntVal = CInt(val)