Use the Excel Export API to Set a Worksheet Name

• Sep 19, 2023

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

View Example: Excel Export API

• C#
• VB.NET

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

Using sheet As IXlSheet = document.CreateSheet()
    ' Specify the worksheet name.
    sheet.Name = "Sales report"
End Using

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.