/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 vote295 views1 answer
How to concate in c#
C#
46 votes415 views6 answers
Random in unity
C#Unity
0 vote299 views1 answer
Coroutine after another
C#
2 votes306 views1 answer
Vue.createApp is not a function
C#
1 vote314 views1 answer
Assign string value c#
C#
3 votes261 views1 answer
Convert html to pdf c#
C#
1 vote280 views1 answer
How to check if string can be converted to int c#
C#
0 vote320 views1 answer
Unity how to find the smallest value out of 2 numbers
C#
0 vote289 views2 answers
Foreach in arraylist c#
C#
1 vote300 views1 answer
C# convert seconds to hours minutes seconds
C#