How not importing hidden rows?

[netsenior]

Hi there,

Whe importing a sheet, is there a way of not importing hidden rows?

googling around I´ve found the method "getVisible()" at https://github.com/PHPOffice/PhpSpreadsheet project... I guess that the behavior I´m looking for.

thanks a lot!

[patrickbrouwers]

Use onEachRow and handle the persistence yourself by checking if the row is visible or not

[netsenior]

thanks Patrick and congrats for the project! still putting the pieces together... I'll let you know as soon as I get there! more tips are welcome : )

[netsenior]

Hi there!

Inspired by this topic https://phpspreadsheet.readthedocs.io/en/latest/topics/autofilters/#displaying-filtered-rows I ended up with this piece of code. It seems to work, but it always shows me "Yes" where I expect a "No" related to a hidden Excel row...

'''
public function onRow(Row $row)
{
$rowIndex = $row->getIndex();
$obj = new WS(); //class WS extends Worksheet{} //use PhpOffice\PhpSpreadsheet\Worksheet\Worksheet;
$obj->getRowDimension($rowIndex)->getVisible() ? info($rowIndex.' Yes'):info($rowIndex.' No');
return [];
}
'''

[patrickbrouwers]

Maybe you need to set read_only to false here: https://github.com/Maatwebsite/Laravel-Excel/blob/3.1/config/excel.php#L87

[patrickbrouwers]

And probably you shouldn't do new WS, because that would be a new worksheet, not the one your are reading.

You can get the correct worksheet by calling $row->getWorksheet()