/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

11 votes337 views2 answers
Unity 2d raycast mouse
C#
0 vote352 views1 answer
Concatenation on different lines in f#
C#
3 votes368 views3 answers
C# convert split to list
C#
1 vote379 views2 answers
C# remove all null from list
C#
0 vote345 views2 answers
C# if combobox selected index
C#
0 vote380 views1 answer
Get Component Trail rendere
C#
14 votes327 views2 answers
How to move player with transform. position
C#
1 vote341 views1 answer
.net core add header to soap request
C#
2 votes318 views1 answer
C# print out whole object
C#
0 vote391 views1 answer
How to make a block disappear in unity
C#Unity