Search moodle.org's
Developer Documentation

See Release Notes

  • Bug fixes for general core bugs in 3.10.x will end 8 November 2021 (12 months).
  • Bug fixes for security issues in 3.10.x will end 9 May 2022 (18 months).
  • PHP version: minimum PHP 7.2.0 Note: minimum PHP version has increased since Moodle 3.8. PHP 7.3.x and 7.4.x are supported too.
<?php

namespace PhpOffice\PhpSpreadsheet\Worksheet;

> use Iterator as NativeIterator;
use PhpOffice\PhpSpreadsheet\Cell\Coordinate; use PhpOffice\PhpSpreadsheet\Exception; use PhpOffice\PhpSpreadsheet\Exception as PhpSpreadsheetException;
< class ColumnIterator implements \Iterator
> /** > * @implements NativeIterator<string, Column> > */ > class ColumnIterator implements NativeIterator
{ /** * Worksheet to iterate. * * @var Worksheet */ private $worksheet; /** * Current iterator position. * * @var int */ private $currentColumnIndex = 1; /** * Start position. * * @var int */ private $startColumnIndex = 1; /** * End position. * * @var int */ private $endColumnIndex = 1; /** * Create a new column iterator. * * @param Worksheet $worksheet The worksheet to iterate over * @param string $startColumn The column address at which to start iterating * @param string $endColumn Optionally, the column address at which to stop iterating */ public function __construct(Worksheet $worksheet, $startColumn = 'A', $endColumn = null) { // Set subject $this->worksheet = $worksheet; $this->resetEnd($endColumn); $this->resetStart($startColumn); } /** * Destructor. */ public function __destruct() {
< unset($this->worksheet);
> // @phpstan-ignore-next-line > $this->worksheet = null;
} /** * (Re)Set the start column and the current column pointer. * * @param string $startColumn The column address at which to start iterating *
< * @throws Exception < * < * @return ColumnIterator
> * @return $this
*/
< public function resetStart($startColumn = 'A')
> public function resetStart(string $startColumn = 'A')
{ $startColumnIndex = Coordinate::columnIndexFromString($startColumn); if ($startColumnIndex > Coordinate::columnIndexFromString($this->worksheet->getHighestColumn())) {
< throw new Exception("Start column ({$startColumn}) is beyond highest column ({$this->worksheet->getHighestColumn()})");
> throw new Exception( > "Start column ({$startColumn}) is beyond highest column ({$this->worksheet->getHighestColumn()})" > );
} $this->startColumnIndex = $startColumnIndex; if ($this->endColumnIndex < $this->startColumnIndex) { $this->endColumnIndex = $this->startColumnIndex; } $this->seek($startColumn); return $this; } /** * (Re)Set the end column. * * @param string $endColumn The column address at which to stop iterating *
< * @return ColumnIterator
> * @return $this
*/ public function resetEnd($endColumn = null) {
< $endColumn = $endColumn ? $endColumn : $this->worksheet->getHighestColumn();
> $endColumn = $endColumn ?: $this->worksheet->getHighestColumn();
$this->endColumnIndex = Coordinate::columnIndexFromString($endColumn); return $this; } /** * Set the column pointer to the selected column. * * @param string $column The column address to set the current pointer at *
< * @throws PhpSpreadsheetException < * < * @return ColumnIterator
> * @return $this
*/
< public function seek($column = 'A')
> public function seek(string $column = 'A')
{ $column = Coordinate::columnIndexFromString($column); if (($column < $this->startColumnIndex) || ($column > $this->endColumnIndex)) {
< throw new PhpSpreadsheetException("Column $column is out of range ({$this->startColumnIndex} - {$this->endColumnIndex})");
> throw new PhpSpreadsheetException( > "Column $column is out of range ({$this->startColumnIndex} - {$this->endColumnIndex})" > );
} $this->currentColumnIndex = $column; return $this; } /** * Rewind the iterator to the starting column. */
< public function rewind()
> public function rewind(): void
{ $this->currentColumnIndex = $this->startColumnIndex; } /** * Return the current column in this worksheet.
< * < * @return Column
*/
< public function current()
> public function current(): Column
{ return new Column($this->worksheet, Coordinate::stringFromColumnIndex($this->currentColumnIndex)); } /** * Return the current iterator key.
< * < * @return string
*/
< public function key()
> public function key(): string
{ return Coordinate::stringFromColumnIndex($this->currentColumnIndex); } /** * Set the iterator to its next value. */
< public function next()
> public function next(): void
{ ++$this->currentColumnIndex; } /** * Set the iterator to its previous value. */
< public function prev()
> public function prev(): void
{ --$this->currentColumnIndex; } /** * Indicate if more columns exist in the worksheet range of columns that we're iterating.
< * < * @return bool
*/
< public function valid()
> public function valid(): bool
{ return $this->currentColumnIndex <= $this->endColumnIndex && $this->currentColumnIndex >= $this->startColumnIndex; } }