Laravel Excel - how to remove a row by row number?

Question

I am using Laravel Excel package with Laravel 5.2. I've loaded an .xls file and can read cell values.

Code:

Excel::load($file, function($reader) {

    $sheet = $reader->getSheetByName('Sheet1');
    echo 'value: '.$sheet->getCell('B9');

})->store('xls', storage_path('excel/exports'));

Now If a cell value contains specific text, I want to remove that row and save as a new file. How can I do that?

Answer 1

you could do something like this

 $reader->skip(10)->take(1);

// Limit with skip and take
$reader->($skip, $take);