PHP range()从A到ZZ? [英] PHP range() from A to ZZ?

问题描述

是否有可能使用PHP从A到ZZ *范围?

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

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

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

对我来说，这是行不通的:

For me this didn't work:

range('A', 'ZZ');

它用于PHPExcel，当它给出 BE 作为我要遍历所有列的最高字段时.在这种情况下，我只会得到A，B:

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')

推荐答案

只需尝试一下-(经测试工作正常)

Just Try this- (tested working fine)

function createColumnsArray($end_column, $first_letters = '')
{
  $columns = array();
  $length = strlen($end_column);
  $letters = range('A', 'Z');

  // Iterate over 26 letters.
  foreach ($letters as $letter) {
      // Paste the $first_letters before the next.
      $column = $first_letters . $letter;

      // Add the column to the final array.
      $columns[] = $column;

      // If it was the end column that was added, return the columns.
      if ($column == $end_column)
          return $columns;
  }

  // Add the column children.
  foreach ($columns as $column) {
      // Don't itterate if the $end_column was already set in a previous itteration.
      // Stop iterating if you've reached the maximum character length.
      if (!in_array($end_column, $columns) && strlen($column) < $length) {
          $new_columns = createColumnsArray($end_column, $column);
          // Merge the new columns which were created with the final columns array.
          $columns = array_merge($columns, $new_columns);
      }
  }

  return $columns;
}
echo "<pre>";
print_r( createColumnsArray('BZ'));

从 http://php.net/range

这篇关于PHP range()从A到ZZ?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！