/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

1 vote233 views1 answer
Change partial view based on select asp.net core
C#
0 vote268 views1 answer
SendFileAsync discord
C#
1 vote335 views1 answer
Oculus Unity add haptics
C#Unity
1 vote282 views1 answer
How to configure visual studio for unity
C#
0 vote264 views1 answer
Automapper.automappermappingexception: 'error mapping types.' .net.core site:forums.asp.net
C#
5 votes250 views1 answer
How to refer parent class unityu
C#Unity
1 vote278 views1 answer
How to spawn coins randomly around the screen unity 2d
C#Unity
0 vote261 views1 answer
C# remove exit icon
C#
28 votes267 views2 answers
Unity switch
C#Unity
6 votes255 views3 answers
Disable rigidbody unity
C#