/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 vote292 views1 answer
C# process start
C#
47 votes230 views5 answers
Remove last character from stringbuilder c#
C#
1 vote223 views1 answer
Animations for pause menu
C#
0 vote248 views1 answer
Qtablewidget add image
C#
0 vote252 views1 answer
C# .net 3.5 post json httpclient
C#
0 vote257 views1 answer
Exceldatareader example c#
C#
0 vote236 views1 answer
No IUserTwoFactorTokenProvider<TUser> named 'Default' is registered.'
C#
2 votes211 views1 answer
Get position of gameobject unity
C#
2 votes223 views2 answers
HCF of number
C#
0 vote213 views1 answer
C# keyboard enter
C#