Help Centre › Building Processes
This article describes the RPA Excel functionality to ungroup rows.
For a full list of available functions, please read EXCEL functions.
Description
The EXCEL Ungroup rows function removes the outline (grouping) from one or more rows, so they can no longer be collapsed or expanded.
Setting it up
To use the EXCEL Ungroup rows function, follow these instructions:
{{popups:rpas/add:action=excel-rows-ungroup}}
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 Ungroup 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 ungroup, 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 |
Tips
- If rows are not grouped, this action has no effect