/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 vote271 views1 answer
Byte array to bitmap C
C#
0 vote289 views1 answer
C# foreach object in array json
C#
0 vote287 views2 answers
Get index of item unity
C#Unity
3 votes281 views2 answers
Unity instantiate empty gameobject
C#
0 vote278 views1 answer
Linq query to check if record exists
C#
1 vote270 views1 answer
How to find the tag of an objecdt in unity
C#
0 vote292 views1 answer
Does Registry.CurrentUser.OpenSubKey create the key if it does not exist?
C#
1 vote288 views1 answer
C# not
C#
1 vote277 views1 answer
How can I cast string to enum?
C#
0 vote335 views3 answers
Instantiate object inside of object Unity
C#Unity