/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

2 votes320 views1 answer
Unity check for internet connection
C#Unity
0 vote284 views1 answer
Flutter find a widget
C#
2 votes271 views2 answers
C# filter list
C#
0 vote293 views1 answer
C# datagridview cell click event
C#
0 vote290 views1 answer
Select from list c#
C#
10 votes308 views2 answers
Unity find gameobject by name
C#Unity
4 votes288 views2 answers
OpenFileDialog c#
C#
0 vote271 views1 answer
C# try catch with error message
C#
0 vote273 views1 answer
C# findindex
C#
1 vote279 views1 answer
Constructor in C#
C#