I have an Excel file with 4 columns I use PAD to loop through the excel file inside the loop is an If action that updates column status if column status is empty. So far it is working but the problem occurs when I tried to put a another if action that checks if the entire row is empty I could not make it work my theory is that PAD cannot read the entire row so I made it read each column by use of else if action then Next loop action to skip the empty rows. This fails though when it comes to column status since column status is always empty I believe this could be resolve with the use of the logical operator OR but I could not find the correct syntax since the examples from the documentation has two operands while am using the isEmpty operand which only has one.
I am open to other ideas if there is away to check if CurrentItem row is empty without the use of multiple else if actions then that would be much better. Thank you
