问如何将列号（如127）转换为Excel列（如AA）？

=SUBSTITUTE(ADDRESS(1;colNum;4);"1";"")

Function GetColumnName(colNum As Integer) As String

    Dim d As Intege

    Dim m As Intege

    Dim name As String

    d = colNum

    name = ""

    Do While (d > 0)

        m = (d - 1) Mod 26

        name = Chr(65 + m) + name

        d = Int((d - m) / 26)

    Loop

    GetColumnName = name

End Functionc

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;

}