How to: Rename a Worksheet

This example demonstrates how to rename a worksheet. To do this, use the Worksheet.Name property of the corresponding Worksheet object.

// Change the name of the second worksheet.
workbook.Worksheets[1].Name = "Renamed Sheet";

When naming a worksheet, take into account the following constraints:

  • The worksheet name must not be equal to an existing name in the collection of worksheets (IWorkbook.Worksheets).
  • The worksheet name must not exceed 31 characters.
  • The worksheet name must not contain the following symbols: , /, ?, :, *, [ or ].
  • The worksheet name must not start or end with a single quote (').
  • The worksheet name must not be an empty string.

The SpreadsheetControl.SheetRenaming and SpreadsheetControl.SheetRenamed events are raised before and after the worksheet is renamed via the control's UI, respectively.

SpreadsheetControl_Worksheet_Indexes

See Also