Checking whether certain cells have been filled in an excel sheet

Help Studio
1

Hello everyone,

I currently running a process that gets certain cells from a spreadsheet.

However I need to make an ‘IF’ activity for the case that the certain cells may not be filled in.

Lets say if any of these cells C2 D2 E2 are empty, what condition can I use to check if they are empty or not?

2

@dvn You can use , yourVariable is Nothing if yourVariable is of Object Type, or String.IsNullOrEmpty(yourVariable) or String.IsNullOrWhitespace(yourVariable) if it is a String

1 Like
3

Hi friend

I assume you are using a for each row?

If condition could be like : row(“columnName”).tostring <> “”

4

will be easier and safer to use like this:
String.IsNullOrEmpty(Convert.ToString(row("columnName")))

1 Like