Help Centre › Building Processes
This article describes the RPA Excel functionality to rename an existing sheet in a workbook.
For a full list of available functions, please read EXCEL functions.
Description
The EXCEL rename sheet function allows you to rename an existing sheet's name.
Setting it up
To use the EXCEL navigate function, follow these instructions:
{{popups:rpas/add:action=excel-rename-sheet}}Once on a process map:
- Navigate to the process where you would like to add the EXCEL rename sheet 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, which will make a new form appear
- From here you can select the EXCEL rename sheet option
- Click "Add" once you are done
Inputs
- File path: The full path to the document you want to work with
- Sheet: The name of the sheet you wish to rename
- New name: The new name for the excel sheet
- Overwrite if exists: Toggle to allow the sheet to rename a similarly named sheet to be overwritten.
Input parameters
| Parameter | Required | Type | Default | Description |
|---|---|---|---|---|
| File path | Yes | Text | – | Full path to the Excel file. |
| Sheet | Yes | Text | – | Current name of the sheet. |
| New name | Yes | Text | – | New name for the sheet. |
| Overwrite if exists | No | Boolean | Off | Overwrite an existing sheet with the same name. |
Output variables
This action does not produce any output variables.
Errors
| Error | Description |
|---|---|
| Sheet not found | The specified sheet does not exist. |
| Name already exists | A sheet with the new name already exists and overwrite is off. |