Issue with converting double value to string

excel

#1

Hi,

In my process the robot has to read a cell in excel which is 8,5 and enter it in a system form.
But when the number is entered it appears as 8.5 with a dot instead of the comma-separated value 8,5.

As the form only accepts comma-values the robot stops.

The read cell acitivity outputs a double-variable, but the Type into activity requires a string. So when I convert to string like var.ToString, the conversion switches dot with a comma for some reason.

I think I have fixed the issue by using the replace function, like var.ToString(Replace("." , “,”)

But do anyone know what else I could have done?


#2

Hello @skandi,

Try to execute setCurrentCulture method before reading or writting:

Regards,
Susana