/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

-1 vote250 views1 answer
Load Level Action for unity
C#Unity
2 votes231 views2 answers
Save file tar.gz c#
C#
2 votes216 views1 answer
How to download something from onedrive unity
C#Unity
0 vote226 views2 answers
Append multi lines to file linux
C#
25 votes228 views4 answers
Unity movetowards
C#
0 vote277 views1 answer
C# int cast error
C#
1 vote223 views2 answers
C# delay
C#
0 vote217 views3 answers
How to deserialize string array in c#
C#
2 votes254 views1 answer
Serilog log level hierarchy
C#
0 vote229 views2 answers
Generate jwt token authorize(roles = admin ) not working .net core 403
C#