Back to Devexpress

How to: Rename a Worksheet

officefileapi-12108-spreadsheet-document-api-examples-worksheets-how-to-rename-a-worksheet.md

latest1.5 KB
Original Source

How to: Rename a Worksheet

  • Sep 19, 2023

Important

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use these examples in production code.

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

View Example

csharp
// Change the name of the second worksheet.
workbook.Worksheets[1].Name = "Renamed Sheet";
vb
' 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 (Workbook.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 and end with a single quote (‘).
  • The worksheet name must not be an empty string.