class ColumnCellIteratorTest in Loft Data Grids 6.2

Hierarchy

• class \ColumnCellIteratorTest extends \PHPUnit_Framework_TestCase

File

vendor/phpoffice/phpexcel/unitTests/Classes/PHPExcel/Worksheet/ColumnCellIteratorTest.php, line 3

class ColumnCellIteratorTest extends PHPUnit_Framework_TestCase {
  public $mockWorksheet;
  public $mockColumnCell;
  public function setUp() {
    if (!defined('PHPEXCEL_ROOT')) {
      define('PHPEXCEL_ROOT', APPLICATION_PATH . '/');
    }
    require_once PHPEXCEL_ROOT . 'PHPExcel/Autoloader.php';
    $this->mockCell = $this
      ->getMockBuilder('PHPExcel_Cell')
      ->disableOriginalConstructor()
      ->getMock();
    $this->mockWorksheet = $this
      ->getMockBuilder('PHPExcel_Worksheet')
      ->disableOriginalConstructor()
      ->getMock();
    $this->mockWorksheet
      ->expects($this
      ->any())
      ->method('getHighestRow')
      ->will($this
      ->returnValue(5));
    $this->mockWorksheet
      ->expects($this
      ->any())
      ->method('getCellByColumnAndRow')
      ->will($this
      ->returnValue($this->mockCell));
  }
  public function testIteratorFullRange() {
    $iterator = new PHPExcel_Worksheet_ColumnCellIterator($this->mockWorksheet, 'A');
    $ColumnCellIndexResult = 1;
    $this
      ->assertEquals($ColumnCellIndexResult, $iterator
      ->key());
    foreach ($iterator as $key => $ColumnCell) {
      $this
        ->assertEquals($ColumnCellIndexResult++, $key);
      $this
        ->assertInstanceOf('PHPExcel_Cell', $ColumnCell);
    }
  }
  public function testIteratorStartEndRange() {
    $iterator = new PHPExcel_Worksheet_ColumnCellIterator($this->mockWorksheet, 'A', 2, 4);
    $ColumnCellIndexResult = 2;
    $this
      ->assertEquals($ColumnCellIndexResult, $iterator
      ->key());
    foreach ($iterator as $key => $ColumnCell) {
      $this
        ->assertEquals($ColumnCellIndexResult++, $key);
      $this
        ->assertInstanceOf('PHPExcel_Cell', $ColumnCell);
    }
  }
  public function testIteratorSeekAndPrev() {
    $iterator = new PHPExcel_Worksheet_ColumnCellIterator($this->mockWorksheet, 'A', 2, 4);
    $columnIndexResult = 4;
    $iterator
      ->seek(4);
    $this
      ->assertEquals($columnIndexResult, $iterator
      ->key());
    for ($i = 1; $i < $columnIndexResult - 1; $i++) {
      $iterator
        ->prev();
      $this
        ->assertEquals($columnIndexResult - $i, $iterator
        ->key());
    }
  }

  /**
   * @expectedException PHPExcel_Exception
   */
  public function testSeekOutOfRange() {
    $iterator = new PHPExcel_Worksheet_ColumnCellIterator($this->mockWorksheet, 'A', 2, 4);
    $iterator
      ->seek(1);
  }

  /**
   * @expectedException PHPExcel_Exception
   */
  public function testPrevOutOfRange() {
    $iterator = new PHPExcel_Worksheet_ColumnCellIterator($this->mockWorksheet, 'A', 2, 4);
    $iterator
      ->prev();
  }

}

Members

Name	Modifiers	Type	Description	Overrides
ColumnCellIteratorTest::$mockColumnCell	public	property
ColumnCellIteratorTest::$mockWorksheet	public	property
ColumnCellIteratorTest::setUp	public	function
ColumnCellIteratorTest::testIteratorFullRange	public	function
ColumnCellIteratorTest::testIteratorSeekAndPrev	public	function
ColumnCellIteratorTest::testIteratorStartEndRange	public	function
ColumnCellIteratorTest::testPrevOutOfRange	public	function	@expectedException PHPExcel_Exception
ColumnCellIteratorTest::testSeekOutOfRange	public	function	@expectedException PHPExcel_Exception