PHP range() from A to ZZ?

by

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;
}

More Related Contents:

  1. How to check if an integer is within a range?
  2. How to check an IP address is within a range of two IPs in PHP?
  3. PHP: Create an array for a range
  4. How to check if an integer is within a range of numbers in PHP?
  5. php switch case statement to handle ranges
  6. Function To Create Regex Matching a Number Range
  7. Parsing HTTP_RANGE header in PHP
  8. PHP store hours, closed dates [closed]
  9. How to get like ‘next monday’ records from mysql database?
  10. Cannot simply use PostgreSQL table name (“relation does not exist”)
  11. Automatic post-registration user authentication
  12. Best way to do multiple constructors in PHP
  13. Best way to test for a variable’s existence in PHP; isset() is clearly broken
  14. Remove useless zero digits from decimals in PHP
  15. json_encode function: special characters
  16. Calculate difference between two dates using Carbon and Blade
  17. php $_GET and undefined index
  18. PHP CURL CURLOPT_SSL_VERIFYPEER ignored
  19. Strange behaviour with numbers that have a leading zero [duplicate]
  20. Removing last comma in PHP?
  21. What is an .inc and why use it?
  22. How to generate a new GUID?
  23. how to properly use while loop in PDO fetchAll
  24. Weird error using PHP Simple HTML DOM parser
  25. Composer Update failed — out of memory
  26. How to reverse order output of a MySQL query
  27. Simple HTML Dom: How to remove elements?
  28. POST a file string using cURL in PHP?
  29. How to stop GD2 from washing away the colors upon resizing images?
  30. Merge two PNG images with PHP GD library

Leave a Comment