Uipath changes the comma to a dot, when reading excel

Hi there.
I have a problem with the Excel format, I have a file that has a numeric column with two decimal places (Spanish format). When the robot hits the cell in my application changes “Coma” by “point” and this gives me error.
How can I do to keep the formats?
I use the “Read Range” activity and tell it “Converse format”, but it doesn’t work.
I have read some cases in the forum and I cannot touch the regional settings of the machine.
In the screenshots you can see how I have it in excel and how it is inserted.
Captura de pantalla 2021-08-30 a las 22.39.35Captura de pantalla 2021-08-30 a las 22.39.15
Captura de pantalla 2021-08-30 a las 22.43.20
Thanks.

Hi,

Can you try to use the following expression in Assign activity before ExcelApplicationScope?

System.Threading.Thread.CurrentThread.CurrentCulture = new System.Globalization.CultureInfo("es-ES")

img20210831-1

Note: This will affect not only number format but also datetime format etc.

Regards,

2 Likes

Hello and thank you very much, this solution has worked perfectly for me.
a greeting
Captura de pantalla 2021-08-31 a las 7.26.56
Captura de pantalla 2021-08-31 a las 7.27.14

1 Like

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