Help Centre › Building Processes
This article describes the RPA Loop functionality to each sheet in an Excel file.
For a full list of available functions, please read LOOP functions.
Description
The LOOP Each sheet in an Excel file function allows you to each sheet in an Excel file.
Setting it up
To use the LOOP Each sheet in an Excel file function, follow these instructions:
{{popups:rpas/add:action=loop-excel-sheet}}
Once on a process map:
- Navigate to the process where you would like to add the LOOP Each sheet in an Excel file 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 sheet in an Excel file option
- Click "Add" once you are done
Input parameters
| Parameter | Required | Type | Default | Description |
|---|---|---|---|---|
| File | Yes | Text | - | The path to the Excel file |
| Variable | Yes | Text | - | Variable to store the current sheet name |
| Include hidden sheets | No | Switch | Off | Also iterate over hidden sheets |
| Max iterations | No | Number | - | Maximum iterations |
Output variables
| Variable | Type | Description |
|---|---|---|
| Variable | Text | The current sheet name in each iteration |
Errors
| Error | Description |
|---|---|
| File not found | The Excel file does not exist |
Tips
- Loops through all sheets in an Excel workbook
- Enable hidden sheets to include sheets that are not visible