i'm using phpexcel library data cells. implemented phpexcel_reader_ireadfilter iterface , set in reader object read data custom range(b1:j50 e.g). works fine reader doesn't empty cells, need them. call iterateonlyexistingcells(false), reader ignoring filter , cells.
class cellsfilter implements phpexcel_reader_ireadfilter { private $startcellname; private $startcellvalue; private $endcellname; private $endcellvalue; private $additionalcells; public function __construct($strrange) { $this->initializerange($strrange); } public function readcell($column, $row, $worksheetname = '') { if ($row >= $this->startcellvalue && $row <= $this->endcellvalue) { if (in_array($column, range($this->startcellname, $this->endcellname))) { return true; } } return false; }
Comments
Post a Comment