I have a task with an excel file in a specific column that filled with number. I am able to create a flow that for each row in that column, robot do some tasks and after it finished it will replace the value with blank ("")
Please note that sometimes the value will be left blank or it will still has value like this
My question: What is the command to enable the robot to determine whether the column has no data? because when i try to count the row on the first picture, it returns 8 row as it treated the blank cell as an actual row so that i couldnt use db is nothing or null.