Help Centre › Building Processes
This article describes the RPA Excel functionality to hide all sheets.
For a full list of available functions, please read EXCEL functions.
Description
The EXCEL Hide all sheets function allows you to hide all sheets.
Setting it up
To use the EXCEL Hide all sheets function, follow these instructions:
{{popups:rpas/add:action=excel-sheet-hide-all}}
Once on a process map:
- Navigate to the process where you would like to add the EXCEL Hide all 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 Hide all sheets option
- Click "Add" once you are done
Input parameters
| Parameter | Required | Type | Default | Description |
|---|---|---|---|---|
| File | Yes | Text | - | The path to the Excel file |
Output variables
This action does not produce output variables.
Errors
| Error | Description |
|---|---|
| File not open | The Excel file must be open |
Tips
- Hides all sheets except the active one
- At least one sheet must remain visible