Keep Decimal Places as is when read from excel

Help Studio
, ,
1

I was reading a value from excel column which is 13.00. When it comes to UiPath runtime it is removing the decimal giving backup as 13, similarly for 8.60 it is giving 8.6.
How can get the exact value without removing the decimal places?

2

Hi @niranjan.kodakandla

While using Read Range activity tick the Preserve Format option in the proprtties Panel.
image

image
image363×800 19.2 KB

Hope it helps!!
Regards,

3

I am using older version of ACtivity and dont see this property in my activity

4

@niranjan.kodakandla

Which version are you using?
Regards,

5

@niranjan.kodakandla

Convert.ToDouble(yourExcelCellValue.ToString())

Hope it helps

6

Then you should upgrade to the latest versions of your dependencies.

7

When you read a value from an Excel column in UiPath, the value is often read as a generic data type like Double, which might not display trailing zeros. To ensure that the exact value with decimal places is retained, you can use the ToString method with a format specifier.

8

.ToString is used when outputting values, it isn’t used when reading values from Excel and doesn’t affect the format of what’s in the datatable.