/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 vote153 views1 answer
Remove first character in a string c#
C#
0 vote112 views1 answer
How to set foreground from code wpf
C#
0 vote141 views1 answer
Razor preview
C#
45 votes129 views6 answers
Foreach dictionary c#
C#
1 vote160 views1 answer
Convert dto to dictionary c#
C#
0 vote149 views1 answer
Button pervious for picturebox c#
C#
4 votes76 views1 answer
C# get month name
C#
0 vote113 views1 answer
Turtle graphics face in direction
C#
2 votes125 views1 answer
How to make a button open window in wpf
C#
-1 vote117 views1 answer
C# unhandled exception in thread
C#