/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 vote358 views1 answer
Remove force unity
C#Unity
0 vote330 views1 answer
Dotween dovalue
C#
3 votes325 views1 answer
Read folder c#
C#
5 votes336 views2 answers
C# remove first three characters from string
C#
0 vote347 views1 answer
Instantiate object in circle
C#
0 vote304 views1 answer
C# convertir caracter con tilde
C#
0 vote340 views1 answer
Handlebars c# datetime now
C#
0 vote293 views1 answer
C# #region #endregion
C#
6 votes318 views1 answer
": ?" operator in c#
C#
5 votes296 views1 answer
C# linq to dictionary
C#