Remove hidden rows when reading file with phpExcel?
<p>When reading a sheet with phpExcel using the toArray method, hidden rows are also parsed.</p>

<p>Is there a method I can use before toArray to remove hidden rows?</p>

<p>Code so far, using Codeigniter</p>

<pre><code>$this-&gt;load-&gt;library('excel');
$objPHPExcel = PHPExcel_IOFactory::load($upload_data['full_path']);

foreach ($objPHPExcel-&gt;getAllSheets() as $sheet) {
    $sheets[$sheet-&gt;getTitle()] = $sheet-&gt;toArray();
}

$data = array();
foreach ($sheets['Data'] as $key =&gt; $row) {
    if ($key &gt; 0) {
        $item = array();
        $item['name'] = $row[1];
        $item['code'] = $row[2];
        $data[] = $item;
    }
}
</code></pre>