[PHP知识库]php excel 根据数字得到列头，如（ABC……AAAB……CHYCHZ……）

$this->int3Excel(88453);

function int2Excel($num)
{
    $m = (int)($num % 26);
    $q = (int)($num / 26);
    $letter = chr(ord('A') + $m);
    if ($q > 0) {
        return int2Excel($q - 1) . $letter;
    }
    return $letter;
}

function int3Excel($num){
    if ($num > 26){
        $count = floor($num/26);
        $count2 = $num%26;
        $a = $this->int3Excel($count-1);
        $b = $this->int2Excel($count2);
        return $a.$b;
    }else{
        return $this->int2Excel($num);
    }
}