Rename a Worksheet

Renames an existing worksheet in the same Excel file.

Overview

This procedure renames an existing worksheet within the same Excel file (workbook). The worksheet content, styles, and formatting are preserved during the rename operation.

Syntax

Below is a line-by-line overview of the automation syntax. Expand each line to learn more.

rename a worksheet in the excel where

What does it do?

References an Excel file to rename a worksheet in.

Where does it go?

This phrase should be written on a new line.

Is it required?

✅ Yes — This phrase is required.

Does it require data?

✅ Yes — A reference to the excel must be defined in the automation.

the original worksheet name is "original-worksheet-name"

What does it do?

Specifies the name of the worksheet to rename.

Where does it go?

Indented under rename a worksheet in the excel where.

Is it required?

✅ Yes — This phrase is required.

Does it require data?

✅ Yes — Replace original-worksheet-name with the current name of the worksheet.

Example

the original worksheet name is "Data"

the new worksheet name is "new-worksheet-name"

What does it do?

Specifies the new name for the worksheet.

Where does it go?

Indented under rename a worksheet in the excel where.

Is it required?

✅ Yes — This phrase is required.

Does it require data?

✅ Yes — Replace new-worksheet-name with the desired new name for the worksheet.

Example

the new worksheet name is "Updated_Data"

Examples

1. Rename a Worksheet in the Excel

This example renames an existing worksheet.

rename a worksheet in the excel where
    the original worksheet name is "Data"
    the new worksheet name is "Updated_Data"