Read cell value Excel

Help Studio
, ,
1

Hi,
I am reading workbook cell value which comes as double. When I try to use it as value.ToString I am getting only 0. Why I am not getting the -562.98 value from the cell? Please help.

Thank you,

2

Are you using read cell workbook activity? have you enabled preserve format.
and what is the cell type in excel

image
image694×299 14.2 KB

image
n

3

Thank you, @muktadir
I will try checking the property to preserve format.
When I read cell it says double value.

Thank you,

4

Hi @A_Learner

Can you try this

stringValue = cellValue.ToString("F2")

Regards,

5

What is F2?

Thank you,

6

Hi @A_Learner

→ cellValue is the numeric variable being converted.
→ .ToString("F2") formats the number as a fixed-point number with 2 decimal places.

For example, if cellValue is 123.456, stringValue would be "123.46" (rounded to two decimal places).

Regards

1 Like