Rename Sheet
Renames a sheet in an existing Excel workbook.
Rename Sheet changes the name of one sheet in a workbook.
Add the action
In the Process Designer toolbox, open Excel and pick Rename Sheet (or type Rename Sheet in the search box).
Inputs and outputs
| Field | Direction | Type | Required | What to put / what you get |
|---|---|---|---|---|
| Excel workbook | Input and output | File | Yes | The workbook to change. Pick a File variable: after the step it holds the changed workbook. |
| Old name | Input | Text | Yes | The current name of the sheet. |
| New name | Input | Text | Yes | The new name. |
Example
orders.xlsx with the sheets Orders and Empty, Old name Empty, New name Notes โ the workbook now has Orders and Notes.
Good to know
- If no sheet has the old name, the step fails with "Excel error: Could not find any sheet named 'โฆ' in the current workbook.".
- If another sheet already has the new name, the step fails with "Excel error: A sheet named 'โฆ' already exists in the current workbook.".
- Excel workbook is both the input and the output; the file keeps its name. Only
.xlsxand.xlsmfiles are accepted.