BUG : Excel5 and setReadFilter ?

Topics: Developer Forum, User Forum
Oct 2, 2010 at 12:58 AM
Edited Oct 2, 2010 at 1:23 AM

Hello,

I have one XLS file with 100.000 rows and 8 Columns, i want to parse it step by step, but in Excel5 they try to load whole file at once,

XLSX , CSV works fine , is this bug in Excel5 ?

 

Here my code sample :

class MyReadFilter implements PHPExcel_Reader_IReadFilter
{
  public function readCell($column, $row, $worksheetName = '') {
        // Read row 0 - 50
        if ($row >= 0 && $row <=50)
            return true;
    else
      return false;
    }
}             

  $filter = new MyReadFilter();
  $objReader = PHPExcel_IOFactory::createReader('Excel5');
  $objReader->setReadFilter($filter);

 

PS: I have noticed that if you open ODS files, they have this problem too

Coordinator
Oct 4, 2010 at 10:16 PM
This discussion has been copied to a work item. Click here to go to the work item and continue the discussion.