Help Centre › Building Processes
This article describes the RPA Excel functionality to group columns.
For a full list of available functions, please read EXCEL functions.
Description
The EXCEL Group columns function groups (outlines) one or more columns so they can be collapsed or expanded. This is useful for organising large spreadsheets by allowing users to show or hide sections of columns.
Setting it up
To use the EXCEL Group columns function, follow these instructions:
{{popups:rpas/add:action=excel-columns-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 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 group, 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 |
| Column not found | One or more specified columns do not exist |
Tips
- Grouped columns show a collapse/expand button in the column header area
- You can create nested groups by grouping a subset of already-grouped columns