/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 vote309 views1 answer
Create new object from generic c#
C#
1 vote374 views1 answer
How to open any file on button click in winforms
C#
0 vote341 views1 answer
Pem file string reader c#
C#
0 vote323 views2 answers
C# getforegroundwindow
C#
1 vote312 views1 answer
Get appdata file path c#
C#
0 vote336 views1 answer
Lambda C# select any perform action list call function
C#
0 vote332 views1 answer
Get attribute value of xml element c#
C#
4 votes321 views1 answer
What value of combobox index c#
C#
0 vote297 views1 answer
How to play a random sound at the position that you want in unity
C#
2 votes340 views3 answers
C# make first letter uppercase
C#