for testing and deploying your application
for finding and fixing issues
for empowering human code reviews
<?php
namespace PhpOffice\PhpSpreadsheetTests\Reader;
use PhpOffice\PhpSpreadsheet\Reader\IReadFilter;
/** Define a Read Filter class implementing IReadFilter */
class CsvContiguousFilter implements IReadFilter
{
private $startRow = 0;
private $endRow = 0;
private $filterType = 0;
/**
* Set the list of rows that we want to read.
*
* @param mixed $startRow
* @param mixed $chunkSize
*/
public function setRows($startRow, $chunkSize)
$this->startRow = $startRow;
$this->endRow = $startRow + $chunkSize;
}
public function setFilterType($type)
$this->filterType = $type;
public function filter1($row)
// Include rows 1-10, followed by 100-110, etc.
return $row % 100 <= 10;
public function filter0($row)
// Only read the heading row, and the rows that are configured in $this->_startRow and $this->_endRow
if (($row == 1) || ($row >= $this->startRow && $row < $this->endRow)) {
return true;
return false;
public function readCell($column, $row, $worksheetName = '')
if ($this->filterType == 1) {
return $this->filter1($row);
return $this->filter0($row);
PHPOffice /
PhpSpreadsheet
