How to check if a cell value read from excel file is NULL


#1

I have to read some data (here dates) from an excel sheet and store them in variables (here DateTime) for further processing. My bot needs to check if these optional fields contain any date and then only do the processing.

How to check if there is any data in the cell?
Can i check if the value of the variable is NULL? Or some other way?

Thanks,


#2

could you use isnothing(VARIABLE) ?


#3

Hello @sarikaaggarwal,

DateTime can’t be null. You can check for it to be equal to DateTime.MinValue

Regards,
Susana


#4

Store it in a variable of type string and use Equals function.
Assume name of the variable of type string = variableDate then use -
variableDate.equals("") or variableDate.equals(“NULL”)