Help Centre › Building Processes
This article describes the RPA Excel functionality to sort sheets alphabetically within a workbook.
For a full list of available functions, please read EXCEL functions.
Description
The EXCEL Sort sheets function reorders all sheets in the workbook alphabetically (ascending or descending). You can optionally pin specific sheets to stay at the beginning or end of the workbook regardless of alphabetical order.
Setting it up
To use the EXCEL Sort sheets function, follow these instructions:
{{popups:rpas/add:action=excel-sort-sheets}}
Once on a process map:
- Navigate to the process where you would like to add the EXCEL Sort sheets 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 EXCEL Sort sheets option
- Click "Add" once you are done
Input parameters
| Parameter | Required | Type | Default | Description |
|---|---|---|---|---|
| Order | No | Select | Ascending | Sort direction: Ascending (A–Z) or Descending (Z–A) |
| Pin at start | No | Text | – | Comma-separated sheet names to keep at the beginning |
| Pin at end | No | Text | – | Comma-separated sheet names to keep at the end |
Output variables
This action does not produce any output variables.
Errors
| Error | Description |
|---|---|
| File not open | The Excel file must be open |
Tips
- Use Pin at start to keep summary or index sheets at the front (e.g. "Summary, Index")
- Use Pin at end to keep reference or lookup sheets at the back (e.g. "Lookup, Config")
- Pinned sheets maintain the order you specify; all other sheets are sorted alphabetically between them