How to read a table from an Excel document that has empty rows using Laravel

Question

Hello guys i have a problem reading a table from an Excel document that doesnt start from raw 1 colone 1 (A1) using LARAVEL, in this docuement there is a title and some empty rows, as the image show : Excel table image

here is the code that i have used to load a table from the document, meanwhile it works fine if i deleted all the title text and all the empty cells !

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

// Getting all results
$results = $reader->get();
foreach ($results as $r =>$v) {
     $person = new Person;
        $person->name = $v['name'];
        $person->age = $v['age'];
        $person->save();
}

What extension or tool do you use to read excel files?

theMohammedA
– theMohammedA

2016-07-18 16:41:51 +00:00
Commented Jul 18, 2016 at 16:41 — theMohammedA
– theMohammedA, Commented Jul 18, 2016 at 16:41
i'm using maatwebsite/excel

RiomoX Mouad
– RiomoX Mouad

2016-07-18 16:45:56 +00:00
Commented Jul 18, 2016 at 16:45 — RiomoX Mouad
– RiomoX Mouad, Commented Jul 18, 2016 at 16:45

RiomoX Mouad · Accepted Answer · 2016-07-19 10:38:36Z

1

Yupiiii!! found a solution for this issue, by going to the config file : \laravel-Project\config\excel.php and change the following line:

  /*
    |--------------------------------------------------------------------------
    | First Row with data or heading of data
    |--------------------------------------------------------------------------
    |
    | If the heading row is not the first row, or the data doesn't start
    | on the first row, here you can change the start row.
    |
    */

    'startRow'                => 1,

and change the number 1 by whatever row your table start ^^ !

answered Jul 19, 2016 at 10:38

RiomoX Mouad

635 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to read a table from an Excel document that has empty rows using Laravel

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related