Help Centre › Building Processes
This article describes the RPA Excel functionality to ungroup columns.
For a full list of available functions, please read EXCEL functions.
Description
The EXCEL Ungroup columns function removes the outline (grouping) from one or more columns, so they can no longer be collapsed or expanded.
Setting it up
To use the EXCEL Ungroup columns function, follow these instructions:
{{popups:rpas/add:action=excel-columns-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 columns option
- Click "Add" once you are done
Input parameters
| Parameter | Required | Type | Default | Description |
|---|---|---|---|---|
| Sheet | Yes | Text | - | The name of the sheet |
| Columns | Yes | Textarea | - | Column names or letters to ungroup, separated by line breaks |
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 columns are not grouped, this action has no effect