Help Centre › Building Processes
This article describes the RPA Excel functionality to group rows.
For a full list of available functions, please read EXCEL functions.
Description
The EXCEL Group rows function groups (outlines) one or more rows so they can be collapsed or expanded. This is useful for organising large spreadsheets by allowing users to show or hide sections of data.
Setting it up
To use the EXCEL Group rows function, follow these instructions:
{{popups:rpas/add:action=excel-rows-group}}
Once on a process map:
- Navigate to the process where you would like to add the function
- Click on the green button’s drop-down
- Click on “+ Activity”
- Select the EXCEL Group rows option
- Click "Add" once you are done
Input parameters
| Parameter | Required | Type | Default | Description |
|---|---|---|---|---|
| Sheet | Yes | Text | - | The name of the sheet |
| Rows | Yes | Textarea | - | Row numbers to group, one per line |
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 |
| Invalid row | One or more row numbers are invalid |
Tips
- Grouped rows show a collapse/expand button in the row header area
- You can create nested groups by grouping a subset of already-grouped rows