/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

30 votes342 views3 answers
How to create a list in c# unity
C#
0 vote325 views1 answer
Automapper.automappermappingexception: 'error mapping types.' .net.core site:forums.asp.net
C#
6 votes285 views1 answer
Float with 2 decimal places
C#
0 vote318 views1 answer
C# order a sorted list by key
C#
13 votes368 views1 answer
Check for collision unity c#
C#Unity
1 vote321 views1 answer
Throw grenade again csgo
C#
0 vote333 views1 answer
.net core copy file in folder to root
C#
0 vote323 views1 answer
Character stay in ground unity 3d
C#
3 votes318 views1 answer
C sharp split by newline
C#
14 votes413 views2 answers
How to make multiplayer game in unity
C#Unity