teste.XLS (153.9 KB)
Recently i have started to use UIPath to automate some processes that use both SAP and Excel, by exporting some files from SAP and saving them in xls format to later process them.
My problems lies in the fact that when the robot opens the file, the decimal point and the thousands separator get mixed up and i end up with the comma as a thousands separator and the full stop as a decimal point, but when i manually open the file it opens with the correct format. Can anyone tell me why this would happen and how to prevent it from happening?
FYI: My temporary solution has been to get the robot to change the system settings to the same format that it opens with so that it can perform the operations in Excel correctly.
PS: the file i uploaded was downloaded by hand.