/**
* @test
* @covers Plum\PlumExcel\ExcelReader::getIterator()
* @covers Plum\PlumExcel\ExcelReader::getData()
*/
public function getIteratorReturnsIterator()
{
$iterator = $this->reader->getIterator();
$this->assertEquals('col A', $iterator[0][0]);
$this->assertEquals('col B', $iterator[0][1]);
$this->assertEquals('line 1A', $iterator[1][0]);
$this->assertEquals('line 1B', $iterator[1][1]);
$this->assertCount(4, $iterator);
}
<?php
/**
* This file is part of plumphp/plum-excel.
*
* (c) Florian Eckerstorfer <*****@*****.**>
*
* For the full copyright and license information, please view the LICENSE
* file that was distributed with this source code.
*/
use Plum\PlumExcel\ExcelReader;
require_once __DIR__ . '/../vendor/autoload.php';
if (!file_exists(__DIR__ . '/example.xlsx')) {
echo "Please run the write-excel.php first to generate a Excel file.\n";
exit(1);
}
$excel = PHPExcel_IOFactory::load(__DIR__ . '/example.xlsx');
$reader = new ExcelReader($excel);
foreach ($reader->getIterator() as $row) {
print_r($row);
}
