validate excel worksheet name

Question

I'm getting the below error when setting the worksheet name dynamically. Does anyone has regexp to validate the name before setting it ?

• The name that you type does not exceed 31 characters. The name does
• not contain any of the following characters: : \ / ? * [ or ]
• You did not leave the name blank.

Answer 1

You can use the method to check if the sheet name is valid

private bool IsSheetNameValid(string sheetName)
{
    if (string.IsNullOrEmpty(sheetName))
    {
        return false;
    }

    if (sheetName.Length > 31)
    {
        return false;
    }

    char[] invalidChars = new char[] {':', '\\',  '/',  '?',  '*', '[', ']'};
    if (invalidChars.Any(sheetName.Contains))
    {
        return false;
    }

    return true;
}