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

Gokul001 (Gokul Balaji) November 8, 2022, 12:15pm 2

HI @outofshape

Can you try to Read the excel file using Workbook activities?

Regards
Gokul

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