Help Centre › Building Processes
This article describes the RPA Excel functionality to remove sheets.
For a full list of available functions, please read EXCEL functions.
Description
The EXCEL Remove sheets function allows you to remove sheets.
Setting it up
To use the EXCEL Remove sheets function, follow these instructions:
{{popups:rpas/add:action=excel-remove-sheet}}
Once on a process map:
- Navigate to the process where you would like to add the EXCEL Remove 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 Remove sheets option
- Click "Add" once you are done
Input parameters
| Parameter | Required | Type | Default | Description |
|---|---|---|---|---|
| File path | Yes | Text | – | Full path to the Excel file. |
| Sheet | Yes | Text | – | Name of the sheet to remove. |
Output variables
This action does not produce any output variables.
Errors
| Error | Description |
|---|---|
| Sheet not found | The specified sheet does not exist. |
| Cannot remove last sheet | A workbook must contain at least one sheet. |