/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 vote133 views1 answer
Acrylic UWP Title bar C#
C#
11 votes166 views3 answers
Unity pick random number
C#
0 vote178 views1 answer
Convert from data adapter to Ienumerable C#
C#
0 vote152 views1 answer
Vb.net tostring numeric format string
C#
0 vote186 views1 answer
Dyanmically create datatable in c#
C#
1 vote191 views1 answer
How to turn off sprite renderer in unity
C#
0 vote174 views1 answer
Create cursor in NETEZZA
C#
15 votes191 views2 answers
C# list join
C#
0 vote173 views1 answer
Asp.net model display name
C#
0 vote181 views1 answer
C# webclient vs httpclient
C#