Use the Excel Export API to Set a Worksheet Name

The example below demonstrates how to set a worksheet name. To do this, use the IXlSheet.Name property.

using (IXlSheet sheet = document.CreateSheet())
{
    // Specify the worksheet name.
    sheet.Name = "Sales report";
}

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

  • The worksheet name must be unique.
  • 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.