I have a robot that reads a range of data in an excel (e.g. B19:O35) and I am unable to edit these excel file. For each row. the robot proceeds to enter the data into a web application until an empty row and it breaks.
Sometimes rows are left blank in between the data, which means the web application is not filled correctly.
How would I modify my robot to cycle through each row and only enter the data into the web application for the rows with data and skip the rows with no data then perform a break after last row?