/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

4 votes303 views1 answer
C# that creates an integer array and displays the sum of all its element values.
C#
1 vote300 views2 answers
Get connection string from web.config in c#
C#
5 votes358 views1 answer
Unity create scriptableobject asset
C#Unity
0 vote293 views1 answer
Itext7 c# memorystream
C#
0 vote507 views1 answer
OpenBots convert Int to String
C#
3 votes316 views2 answers
Pig sus
C#
1 vote337 views1 answer
Unity up arrow input
C#Unity
0 vote305 views1 answer
Remove compoennt unity
C#
0 vote301 views1 answer
Get date of tomorrow c#
C#
0 vote329 views1 answer
System.InvalidOperationException: 'Transaction has already been rolled back or is not pending'
C#