Dear UiPath Community I have an SAP export to .xls file that formats number with “,” as decimal separator and “.” for thousands. When I open the .xls file manually with excel the formats are correct, but when I use the “Use Excel File” activity it messes up the formatting and transforms “.” into “,…

Update I found a solution by opening the .xls file using “start process” activity (which simulates a “manual open”) and then saving the file as .xlsx When later in the process I open the .xlsx file using the “Use Excel File activity” it works fine and does not mess up the separators. [image]

Use Excel File messes up decimal/thousand separator

Help Activities

outofshape (Gubser, Raphael) November 8, 2022, 1:05pm 5

The value “12.980” marked in green will be one that get transformed into “12,98” which is wrong.

Topic		Replies	Views
SAP and Excel Decimal Point Mixup Help excel , sap , activities	4	4321	May 4, 2018
Data loss while extracting data from a .xls file an converting it to a xlsx Help	3	1140	August 23, 2019
Decimal and thousand separator system, CSV File Studio excel , uiautomation , activities , question	5	1272	January 20, 2023
Formatting issues when importing values from xls to SAP Help excel , sap , studio	2	2968	October 15, 2020
How to convert a value to decimal separator Activities excel , activities , question	7	718	October 30, 2023

Use Excel File messes up decimal/thousand separator

Related topics