/C#/C# convert excel column index to letter

C# convert excel column index to letter

private string GetExcelColumnName(int columnNumber)
{
    int dividend = columnNumber;
    string columnName = String.Empty;
    int modulo;

    while (dividend > 0)
    {
        modulo = (dividend - 1) % 26;
        columnName = Convert.ToChar(65 + modulo).ToString() + columnName;
        dividend = (int)((dividend - modulo) / 26);
    } 

    return columnName;
}

Source: stackoverflow.com

Similar codes

0 vote190 views1 answer
Itext7 c# memorystream
C#
0 vote183 views1 answer
Use different database with entitymanagerfactory
C#
0 vote235 views1 answer
How to choose a random child in a gameobject unuity
C#
0 vote195 views1 answer
Provide inject vue
C#
0 vote155 views1 answer
Maximize window c# console
C#
0 vote196 views1 answer
Reference a class by string unity
C#
0 vote190 views1 answer
.net core change localhost port
C#
0 vote191 views2 answers
List string to int c#
C#
0 vote211 views1 answer
How to reload app.config file at runtime in c#
C#
0 vote175 views2 answers
Install sticky notes in ubuntu
C#