/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

13 votes205 views1 answer
How to find the mouse position unity
C#Unity
0 vote136 views1 answer
Windows form button image size
C#
0 vote131 views1 answer
Block wapalyzer from detecting codeigniter
C#
121 votes305 views6 answers
Generate a random number in c#
C#
2 votes130 views3 answers
Unity remove parent
C#
0 vote149 views1 answer
Rename join table ef core
C#
0 vote136 views1 answer
F# convert generic.List to list
C#
0 vote165 views1 answer
Unity mousetoterrainposition
C#Unity
1 vote147 views1 answer
How custom them of ckeditor
C#
0 vote126 views1 answer
Csharp csvhelper
C#