/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 vote359 views1 answer
Cannot implicitly convert type 'void' to 'system.eventhandler'
C#
14 votes329 views2 answers
Unity debug log gameobject
C#
1 vote360 views1 answer
Check if two linked lists merge. If so, where?
C#
32 votes342 views4 answers
How to get keyboard input in unity
C#
1 vote361 views1 answer
Unity2d click on gameobject
C#
0 vote347 views1 answer
Initalize C# project in VS Code
C#
0 vote311 views1 answer
Fill combobox with enum values c#
C#
0 vote465 views1 answer
System.Collections.Generic.List`1[System.Int32] c# fix
C#
17 votes372 views5 answers
Linux delete content of folder
C#
18 votes322 views3 answers
C# decimal vs double
C#