具有逻辑顺序的字母的数字

Question

I have this array which links numbers to letters at the moment like this:

1-26 = A-Z

But there is more, 27=AA and 28=AB etc...

so basically when I do this:

var_dump($array[2]); //shows B
var_dump($array[29]); //shows AC

Now this array I made myself but it's becoming way too long. Is there a way to actually get this going on till lets say 32? I know there is chr but I dont think I can use this.

Is there an easier way to actually get this without using this way too long of an array?

Answer 1

It's slower calculating it this way, but you can take advantage of the fact that PHP lets you increment letters in the same way as numbers, Perl style:

function excelColumnRange($number) {
    $character = 'A';
    while ($number > 1) {
        ++$character;
        --$number;
    }
    return $character;
}

var_dump(excelColumnRange(2));
var_dump(excelColumnRange(29));