/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 vote94 views1 answer
Unity topdown 2d look
C#
0 vote129 views1 answer
Sdl quit event not working multiple windows
C#
0 vote99 views2 answers
.net return context.Result without extra new objectResult
C#
0 vote95 views1 answer
Meaning of ??= in c#
C#
3 votes154 views1 answer
Show private fields in inspecotr unity
C#Unity
0 vote93 views1 answer
Stateteach.net
C#
11 votes115 views4 answers
C# remove all whitespaces from string
C#
0 vote92 views1 answer
Automapper c# initialize error
C#
0 vote101 views1 answer
#ifdef in c
C#
1 vote95 views1 answer
Randomize through array in C#
C#