Excel want's to repair workbook with two sheets and two tables about npoi-examples HOT 2 CLOSED

Hello,

I have found the problem with the changed example. I forgot to change the ctTable.id to i.
Now the example works.
In my code the id was set correctly.
After further testing I identified my values for table.name as the problem.
Some started with _ some with numbers.
I already wrote a function for the sheet names because of its maxLength.

    private static string SanitizeAndTruncateStart(string? toBeChanged, int maxLength = 31)
    {
        if (string.IsNullOrEmpty(toBeChanged)) return string.Empty;
        var sanitizedMemberName = new string(toBeChanged.Where(char.IsLetter).ToArray());
        return TruncateStart(sanitizedMemberName, maxLength);
    }

    private static string TruncateStart(string? toBeChanged, int maxLength = 31)
    {
        if (string.IsNullOrEmpty(toBeChanged)) return string.Empty;
        return toBeChanged.Length > maxLength ? toBeChanged[^maxLength..] : toBeChanged;
    }

Does anyone know the exact rules for table.Name?
I think if the question is answered, the issue can be closed.

Best regards,
Peter

from npoi-examples.

https://learn.microsoft.com/en-us/dotnet/api/documentformat.openxml.spreadsheet.table?view=openxml-3.0.1

name (Name)
A string representing the name of the table that is used to reference the table programmatically through the spreadsheet applications object model. This string shall be unique per table per sheet. It has the same length and character restrictions as for displayName.By default this should be the same as the table's displayName. This name should also be kept in synch with the displayName when the displayName is updated in the UI by the spreadsheet user.The possible values for this attribute are defined by the ST_Xstring simple type (§22.9.2.19).

from npoi-examples.