/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 vote165 views1 answer
C# crud observablecollection -mvvm
C#
0 vote132 views1 answer
Convert list of tuples to dictionary c#
C#
13 votes336 views2 answers
How to make an object move in unity
C#Unity
10 votes145 views3 answers
Get number of days between two dates c#
C#
0 vote163 views1 answer
C# find in dictionary
C#
2 votes158 views1 answer
Change array size in unity
C#
0 vote147 views1 answer
Gameobject.Find in unityC#
C#
2 votes140 views1 answer
C# call main method
C#
0 vote155 views1 answer
Datatable linq where clause c#
C#
5 votes178 views1 answer
How to change rotate with script unity
C#Unity