PHP range() from A to ZZ?

Question

Is it possible to get a range with PHP from A to ZZ*?

a b c ... aa ... zx zy zz

For me this didn't work:

range('A', 'ZZ'); 

It's for PHPExcel, when it gives BE as highest field i'd run through all colums. In this case i only get A, B:

range ('A', 'BE') 

Answer 1

Take advantage of PHP's ability to increment characters "perl-style"

$letters = array(); $letter = 'A'; while ($letter !== 'AAA') {     $letters[] = $letter++; } 

But you could also use simple integer values, and take advantage of PHPExcel's built-in PHPExcel_Cell::stringFromColumnIndex() method

EDIT

From PHP 5.5, you can also use Generators to avoid actually building the array in memory

function excelColumnRange($lower, $upper) {     ++$upper;     for ($i = $lower; $i !== $upper; ++$i) {         yield $i;     } }  foreach (excelColumnRange('A', 'ZZ') as $value) {     echo $value, PHP_EOL; }