/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 vote225 views1 answer
Unity how to get the first word from string
C#Unity
130 votes324 views6 answers
Generate random number c#
C#
0 vote215 views1 answer
How to add 1 year in current datetime in c#
C#
0 vote274 views1 answer
How to change the width of a panel unity
C#Unity
1 vote244 views1 answer
This in unity
C#
4 votes206 views2 answers
C# delete files older than 10 days
C#
0 vote212 views1 answer
How to change argument of function in f#
C#
9 votes226 views3 answers
Get rigidbody component unity
C#Unity
31 votes204 views6 answers
Play tic tac toe
C#
0 vote190 views1 answer
Delayed function unity
C#