Help Centre › Building Processes
This article describes the RPA Excel functionality to unhide rows.
For a full list of available functions, please read EXCEL functions.
Description
The EXCEL Unhide rows function makes previously hidden rows visible again.
Setting it up
To use the EXCEL Unhide rows function, follow these instructions:
{{popups:rpas/add:action=excel-rows-unhide}}
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 Unhide 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 unhide, 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 the specified rows are not hidden, this action has no effect