Problem with "write cell" activity

Help StudioX
,
1

Hey, I have a problem with the activity “write cell”, I have one file into which are entered all the workers that the robot will reprocess (enter them after the activities, at the end of the robot). When I start the robot again, the robot doesn’t see the previously entered workers and starts typing a new row in A2, as it has marked below. What can I do to make the robot type in the first blank row every time?

This image shows a configuration window for a Write Cell activity in an automation workflow, set to write the "ID" from the "CurrentRow" to cell "A2" of the "Zamówione" sheet in the "Excel2" workbook, with the auto increment row option enabled. (Captioned by AI)
This image shows a configuration window for a Write Cell activity in an automation workflow, set to write the "ID" from the "CurrentRow" to cell "A2" of the "Zamówione" sheet in the "Excel2" workbook, with the auto increment row option enabled. (Captioned by AI)485×214 7.08 KB

Thank You! :slight_smile:

2

@sullivanne,

You should be using Find First/Last Data Row activity to get the last filled row. From that last row you can add one to get the first blank row.

1 Like
4

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.