Hello buddies. Please refer to the demo photo below first.
Column A, B, and C are input by me for the robot to perform some task and then the robot will record the running completion date in Column D. Please ignore Column B & C. At the beginning, the robot need to get the Info Number (if D2:D12 are all blank, that means the robot should get A2) as input for something else. After the task with respect to that Info Number is done, it will proceed with another task by getting the next Info Number. The information in that Excel sheet is accumulative.
My current workflow is to
- use the Read Range Activity for the DataTable
- use For Each Row activity to call the 1st number by coding Row.Item(“Info Number”).ToString
However, it will only begin with Row 2 if I use the current workflow. As this Excel sheet is accumulative, the robot should be learnt to realize the 1st row it needs is Row 13 in this case (as it is the first row that is blank in Column D), and run from Row 13 to Row 24.
What is the smart approach to achieve it? Thanks!