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?