Help Centre › Building Processes
This article describes the RPA Loop functionality to each row in an Excel sheet.
For a full list of available functions, please read LOOP functions.
Description
The LOOP Each row in an Excel sheet function allows you to each row in an Excel sheet.
Setting it up
To use the LOOP Each row in an Excel sheet function, follow these instructions:
{{popups:rpas/add:action=loop-excel}}
Once on a process map:
- Navigate to the process where you would like to add the LOOP Each row in an Excel sheet 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 LOOP Each row in an Excel sheet option
- Click "Add" once you are done
Input parameters
| Parameter | Required | Type | Default | Description |
|---|---|---|---|---|
| File path | Yes | Text | – | Full path to the Excel file. |
| Sheet | Yes | Text | – | Name of the sheet to loop through. |
| Variable | Yes | Text | – | Loop variable name to access current row data. |
| Start cell | No | Text | – | First data cell to start from (e.g. A1). |
| Has header row | No | Boolean | Off | First row contains column headers. |
| Max iterations | No | Number | – | Maximum number of rows to process. |
Output variables
| Variable | Type | Description |
|---|---|---|
| Variable | Object | Current row data accessible via {variable::column_name}. |
Errors
| Error | Description |
|---|---|
| File not found | The Excel file does not exist. |
| Sheet not found | The specified sheet does not exist. |
Tips
- Enable 'Has header row' to access columns by name: {row::Column Name}.
- Use loop-break to exit the loop early based on a condition.