/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

-4 votes152 views1 answer
How to set discord status Csharp bot
C#
0 vote147 views1 answer
C# generate insert statement from object
C#
0 vote144 views2 answers
C# To Pascal Case
C#
2 votes150 views1 answer
C# round number down
C#
0 vote157 views1 answer
Unity how to reorder a list
C#
0 vote137 views1 answer
C# read all lines from filestream
C#
0 vote174 views1 answer
C# if break
C#
6 votes166 views1 answer
C# split a string and return list
C#
0 vote169 views1 answer
C# entity framework code first connection string
C#
3 votes152 views1 answer
C# convert double to int
C#