数值、Excel列互转

/**
 * 数值转Excel列
 * @param int $num 整数
 * @return string
 */
function num2excel(int $num): string
{
    $str = '';
    $arr = ['A', 'B', 'C', 'D', 'E', 'F', 'G', 'H', 'I', 'J', 'K', 'L', 'M', 'N', 'O', 'P', 'Q', 'R', 'S', 'T', 'U', 'V', 'W', 'X', 'Y', 'Z'];

    while ($num > -1) {
        $str = $arr[$num % 26] . $str;
        $num = floor($num / 26) - 1;
    }

    return $str;
}

/**
 * excel列转数值
 * @param string $str excel列
 * @return int
 */
function excel2num(string $str): int
{
    $arr = ['A' => 0, 'B' => 1, 'C' => 2, 'D' => 3, 'E' => 4, 'F' => 5, 'G' => 6, 'H' => 7, 'I' => 8, 'J' => 9, 'K' => 10, 'L' => 11, 'M' => 12, 'N' => 13, 'O' => 14, 'P' => 15, 'Q' => 16, 'R' => 17, 'S' => 18, 'T' => 19, 'U' => 20, 'V' => 21, 'W' => 22, 'X' => 23, 'Y' => 24, 'Z' => 25];

    $str = strrev($str); // 反转

    $len = strlen($str);
    $num = $arr[$str[0]];

    for ($i = 1; $i < $len; ++ $i) {
        $num += ($arr[$str[$i]] + 1) * pow(26, $i);
    }

    return $num;
}

v(num2excel(1234));
v(excel2num('AUM'));

运行结果：