How to skip empty cells in when reading a column, there is no value in the cell please advise


that is my condition if there is nothing in the cell values do not send and if there is a value in cell thern send mail… please advise advise me


“is nothing” means that the variable has not been set to anything. What you really want to do is check if empty string “” is the value.

row("MailID").ToString.Trim = ""

Hope that helps.


1 Like

I guess you could try both of below which will check for null,empty,whitespace

if (NOT String.IsNullOrEmpty(val) AND NOT String.IsNullOrWhiteSpace(val))
1 Like

@ClaytonM Thanks you its working :wink:

That working for me too. thank you