PHPOffice / PhpSpreadsheet

use PhpOffice\PhpSpreadsheet\Worksheet\Worksheet;

use PHPUnit_Framework_TestCase;

class ColumnTest extends PHPUnit_Framework_TestCase

{

    public $mockWorksheet;

    public $mockColumn;

    public function setUp()

    {

        $this->mockWorksheet = $this->getMockBuilder(Worksheet::class)

            ->disableOriginalConstructor()

            ->getMock();

        $this->mockWorksheet->expects($this->any())

            ->method('getHighestRow')

            ->will($this->returnValue(5));

    }

    public function testInstantiateColumnDefault()

    {

        $column = new Column($this->mockWorksheet);

        self::assertInstanceOf(Column::class, $column);

        $columnIndex = $column->getColumnIndex();

        self::assertEquals('A', $columnIndex);

    }

    public function testInstantiateColumnSpecified()

    {

        $column = new Column($this->mockWorksheet, 'E');

        self::assertInstanceOf(Column::class, $column);

        $columnIndex = $column->getColumnIndex();

        self::assertEquals('E', $columnIndex);

    }

    public function testGetCellIterator()

    {

        $column = new Column($this->mockWorksheet);

        $cellIterator = $column->getCellIterator();

        self::assertInstanceOf(ColumnCellIterator::class, $cellIterator);

    }

}

use PhpOffice\PhpSpreadsheet\Worksheet\Worksheet;

use PHPUnit_Framework_TestCase;

class RowTest extends PHPUnit_Framework_TestCase

{

    public $mockWorksheet;

    public $mockRow;

    public function setUp()

    {

        $this->mockWorksheet = $this->getMockBuilder(Worksheet::class)

            ->disableOriginalConstructor()

            ->getMock();

        $this->mockWorksheet->expects($this->any())

            ->method('getHighestColumn')

            ->will($this->returnValue('E'));

    }

    public function testInstantiateRowDefault()

    {

        $row = new Row($this->mockWorksheet);

        self::assertInstanceOf(Row::class, $row);

        $rowIndex = $row->getRowIndex();

        self::assertEquals(1, $rowIndex);

    }

    public function testInstantiateRowSpecified()

    {

        $row = new Row($this->mockWorksheet, 5);

        self::assertInstanceOf(Row::class, $row);

        $rowIndex = $row->getRowIndex();

        self::assertEquals(5, $rowIndex);

    }

    public function testGetCellIterator()

    {

        $row = new Row($this->mockWorksheet);

        $cellIterator = $row->getCellIterator();

        self::assertInstanceOf(RowCellIterator::class, $cellIterator);

    }

}