How to find if the variable of type Generic Value is NULL

excel

#1

Hi,

I am populating a variable (say x) of the type GenericValue from excel, using the get row item activity.

Now I need to take action for further processing only if the corresponding string value in the cell has some data. In case the cell is blank, there should be a message logged.

In order to do the above, I need to convert the variable x to a string type for which i am using x.ToString

It compiles fine, but during execution, the case when the cell is blank, the x.ToString throws an error (exception).

I want to check if the value is NULL or “” …

How to do so?

Thanks,
Sarika


#2

Hey @sarikaaggarwal

Check with your_variable is Nothing in if condition. if it will return null value it will return true and if not it will return false.

Regards…!!
AKsh


#3

Thanx so much!! it works!!!