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.
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.
Hello and thank you very much, this solution has worked perfectly for me.
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.