Write Cell to Excel - Double

Help
1

I use Write Cell to write a value to my spread sheet.

The variable (“balVal”) is of data type Double. Example of value is 7.89 (note the dot, not comma).

Because of my geography we use comma as a decimal separator.

UiPath seems to require that I pass a string to the Write Cell activity, so I’ve tried: balVal.ToString.Replace(“.”,“,”) and it does indeed write the value like 7,89 - BUT Excel doesn’t see it as number, but instead text. Beforehand I’ve set up the cells in Excel as number.

Anyone with experience on this matter?

1 Like
2

you should check this

3

Hi @peterelbek,

Did you selected the whole column and format the column to number.

4

None of the above solutions worked for me. In the end I solved it with
“=” & myVariable.ToString

3 Likes
5

this is so cool, i didnt know you can mark your own answer as a solution :smile:

6

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