Hi all, I uploaded an Excel file containing some rows formatted with two decimal places. In my Excel file, the decimal separator is a dot, but the output shows a comma instead. My question is, what do I need to do?
The Excel data uses a period as the decimal separator.
Open file excel
Read Worksheet excel
Output from the Excel file upload during debugging
Best Regards,
Ibnu
Yes, Because it always return as text value thats why you got the , instead of dot. You need to convert it like below.
Hi @Ibnu Nawi ,
Which Forge component are you referring to?
i'm using ppu_advanced_excel
I've already converted the text to decimal, but the debug result is empty.
Not in the CellName after cellname when value assign to variable. Use this coversation .