How to read number double (excel)?

Help Studio
, ,
1

I​ want​ to​ read​ number​ (have​ decimal)​from​ excel.

I create variable​ as​ double.
But after run i​t​ show​ error​
Read​ cell: INST is​ not​ a​ valid value​ for​ double.

Please guide me​ about​ it​

2

please share a sample value, which you want to parse / read with us. Thanks

3

@ppr In​ red​ text.

IMG_20211125_200919
IMG_20211125_2009191920×667 251 KB

IMG_20211125_201107
IMG_20211125_2011071920×610 152 KB

4

the exception message is INST, could it be the case that somewhere a variable name is quoted… or other not intended

in general we would do:
grafik
can use also alternate conversion methods and can control in case of different number formats

5

@ppr I not understand.
How to solve it?

I want to read data from file as below.

data (2).xlsx (9.4 KB)

6

we have different options to parse a double
in case of parsing an empty string we get following exception
grafik
grafik

Incase of we send a non digit value to CDbl eg INSTR
grafik
we get:
grafik

so looking to the excel we dont see any suspicious.
looking to the Exception we more have the feeling that a wrong value is send for the usage.

just share with us a screenshot of the activity causing the exception. Feel free to also share additional relevant details with us

7

@ppr My flow as below.

IMG_20211125_203701
IMG_20211125_2037011920×2649 937 KB

8

replicating your case with your Excel myValue is of Datatype double
grafik
grafik

check all used excels and workheet, that the correct ones are used
check if some cell has the value INST as we can see it on the exception

9

@ppr How to check?

10

with eyes on code and on the excel referenced from Excel Application scope is used

11

Make your values string or objects and then cast them to doubles after pulling them out of excel.