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.