Help Centre › Building Processes
This article describes the RPA Excel functionality to hide rows.
For a full list of available functions, please read EXCEL functions.
Description
The EXCEL Hide rows function hides one or more rows from view. Hidden rows are not deleted – they are simply not visible until unhidden.
Setting it up
To use the EXCEL Hide rows function, follow these instructions:
{{popups:rpas/add:action=excel-rows-hide}}
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 Hide 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 hide, 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
- Hidden rows are not deleted, they are just not visible
- Use Unhide rows to make them visible again