Hello!

I am trying to check for empty rows in a excel range by iterating the data table with a condition. The problem is that one of the cells in the row always contains “0.00” due to a calculation macro in that particular cell. So I’m trying to create a condition which first checks if the row is empty and also if that particular cell is not null or empty, like this:

The excel sheet contains several rows and it always work for the first one, but not the rest. I have tried several combinations in the condition but can’t seem to get it right.

Also when I output the data table the empty rows always turn out like this:

,0, The number of characters in this matches the number of columns I have in my DataTable.

Does this mean that every cell have a comma hidden in them? And the zero is the calculation of “0.00”?

How would I in this case manage to get the first empty row?

Regards