Uipath changes the comma to a dot, when reading excel

[Aguirre]

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.


Thanks.

[Yoichi]

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")

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

Regards,

[Aguirre]

@Yoichi

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

Hello and thank you very much, this solution has worked perfectly for me.
a greeting