Get type of cell value

studio

#1

Hi, I have a read cell activity which returns a generic value.
I would like to ask is it possible to get the type of cell? It tends to be convertible to double, but occasionally other content like a “*” or empty value may appear, in that case if i ask to convert it to double, it will throw an exception.

I would like to see if i can get type of cell content, if it is a system.double i will proceed to parse.


#2

In such cases I would suggest you to use a string variable. Whatever values you get, convert it to string. For arithmetic operations or any other, convert it back


#3

You can use Double.TryParse() method, it returns boolean value true if conversion is successful else false on failure.
You can check the value returned from the expression and proceed accordingly.


closed #4