Help Centre › Building Processes
This article describes the RPA Excel functionality to go to first open row.
For a full list of available functions, please read EXCEL functions.
Description
The EXCEL Go to first open row function allows you to go to first open row.
Setting it up
To use the EXCEL Go to first open row function, follow these instructions:
{{popups:rpas/add:action=excel-goto-open-row}}
Once on a process map:
- Navigate to the process where you would like to add the EXCEL Go to first open row function
- Click on the green button’s drop-down (right side of the green button labelled “Process”)
- On the menu that appears, click on the “+ Activity” item
- From here you can select the EXCEL Go to first open row option
- Click "Add" once you are done
Input parameters
| Parameter | Required | Type | Default | Description |
|---|---|---|---|---|
| Sheet | Yes | Text | - | The name of the sheet |
| Column | Yes | Text | - | The column name to check |
| Minimum row | No | Number | 1 | The minimum row number to start searching from |
Output variables
This action does not produce output variables.
Errors
| Error | Description |
|---|---|
| File not open | The Excel file must be open |
| Sheet not found | The specified sheet does not exist |
Tips
- Finds the first empty row in the specified column
- Useful for appending data to a sheet