123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161 |
- <?php
- /**
- * PHPExcel
- *
- * Copyright (c) 2006 - 2014 PHPExcel
- *
- * This library is free software; you can redistribute it and/or
- * modify it under the terms of the GNU Lesser General Public
- * License as published by the Free Software Foundation; either
- * version 2.1 of the License, or (at your option) any later version.
- *
- * This library is distributed in the hope that it will be useful,
- * but WITHOUT ANY WARRANTY; without even the implied warranty of
- * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU
- * Lesser General Public License for more details.
- *
- * You should have received a copy of the GNU Lesser General Public
- * License along with this library; if not, write to the Free Software
- * Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA
- *
- * @category PHPExcel
- * @package PHPExcel_Worksheet
- * @copyright Copyright (c) 2006 - 2014 PHPExcel (http://www.codeplex.com/PHPExcel)
- * @license http://www.gnu.org/licenses/old-licenses/lgpl-2.1.txt LGPL
- * @version 1.8.0, 2014-03-02
- */
- /**
- * PHPExcel_Worksheet_CellIterator
- *
- * Used to iterate rows in a PHPExcel_Worksheet
- *
- * @category PHPExcel
- * @package PHPExcel_Worksheet
- * @copyright Copyright (c) 2006 - 2014 PHPExcel (http://www.codeplex.com/PHPExcel)
- */
- class PHPExcel_Worksheet_CellIterator implements Iterator
- {
- /**
- * PHPExcel_Worksheet to iterate
- *
- * @var PHPExcel_Worksheet
- */
- private $_subject;
- /**
- * Row index
- *
- * @var int
- */
- private $_rowIndex;
- /**
- * Current iterator position
- *
- * @var int
- */
- private $_position = 0;
- /**
- * Loop only existing cells
- *
- * @var boolean
- */
- private $_onlyExistingCells = true;
- /**
- * Create a new cell iterator
- *
- * @param PHPExcel_Worksheet $subject
- * @param int $rowIndex
- */
- public function __construct(PHPExcel_Worksheet $subject = null, $rowIndex = 1) {
- // Set subject and row index
- $this->_subject = $subject;
- $this->_rowIndex = $rowIndex;
- }
- /**
- * Destructor
- */
- public function __destruct() {
- unset($this->_subject);
- }
- /**
- * Rewind iterator
- */
- public function rewind() {
- $this->_position = 0;
- }
- /**
- * Current PHPExcel_Cell
- *
- * @return PHPExcel_Cell
- */
- public function current() {
- return $this->_subject->getCellByColumnAndRow($this->_position, $this->_rowIndex);
- }
- /**
- * Current key
- *
- * @return int
- */
- public function key() {
- return $this->_position;
- }
- /**
- * Next value
- */
- public function next() {
- ++$this->_position;
- }
- /**
- * Are there any more PHPExcel_Cell instances available?
- *
- * @return boolean
- */
- public function valid() {
- // columnIndexFromString() returns an index based at one,
- // treat it as a count when comparing it to the base zero
- // position.
- $columnCount = PHPExcel_Cell::columnIndexFromString($this->_subject->getHighestColumn());
- if ($this->_onlyExistingCells) {
- // If we aren't looking at an existing cell, either
- // because the first column doesn't exist or next() has
- // been called onto a nonexistent cell, then loop until we
- // find one, or pass the last column.
- while ($this->_position < $columnCount &&
- !$this->_subject->cellExistsByColumnAndRow($this->_position, $this->_rowIndex)) {
- ++$this->_position;
- }
- }
- return $this->_position < $columnCount;
- }
- /**
- * Get loop only existing cells
- *
- * @return boolean
- */
- public function getIterateOnlyExistingCells() {
- return $this->_onlyExistingCells;
- }
- /**
- * Set the iterator to loop only existing cells
- *
- * @param boolean $value
- */
- public function setIterateOnlyExistingCells($value = true) {
- $this->_onlyExistingCells = $value;
- }
- }
|