/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 vote332 views1 answer
Best programming language for compression ratio
C#
0 vote281 views1 answer
For what is percent sign in unity c#
C#Unity
3 votes267 views2 answers
Unity create empty gameobject in code
C#
2 votes235 views1 answer
Parse excel file to class object c#
C#
0 vote261 views1 answer
Conncet oracle database in c# visual studio
C#
0 vote249 views2 answers
Extension of c sharp
C#
0 vote253 views1 answer
How to create vg in aix
C#
0 vote244 views1 answer
How to destroy bridges animal crossing
C#
1 vote224 views14 answers
}
C#
-1 vote208 views1 answer
Window.location c#
C#