How to skip first row when importing file

Question

I'm trying to import an .xlsx file in Laravel version 5.7 using Maatwebsite-excel version 3.1. What I want to achieve is to skip the first row of the file to avoid importing column headers in my database.

I've tried to use version 2 syntax, calling the skip() method.

public function voter_import(Request $request)
{
    if (empty($request->file('file')->getRealPath())) 
    {
        return back()->with('success','No file selected');
    }
    else 
    {
        Excel::import(new VotersImport, $request->file('file'))->skip(1);
        return response('Import Successful, Please Refresh Page');
    }
}

class VotersImport implements ToModel
{
public function model(array $row)
   {
    return new Voter([
      'fname'          =>  $row[0],
      'lname'          =>  $row[1],
      'phone'          =>  $row[2],
      'gender'         =>  $row[3],
      'state'          =>  $row[4],
      'occupation'     =>  $row[5],
      'address'        =>  $row[6],
      'vin'            =>  $row[7],
      'dob'            =>  $row[8],
      'campaign_id'    =>  $row[9],
    ]);
   }
}

error message:

Call to undefined method Maatwebsite\Excel\Excel::skip()

Can you provide code from `VotersImport`? – mare96 Jun 23 '19 at 18:44 — mare96, Jun 23 '19 at 18:44

score 66 · Accepted Answer · answered Jun 23 '19 at 22:58

66

you can implement the StartingRow

use Maatwebsite\Excel\Concerns\WithStartRow;

class VotersImport implements ToModel, WithStartRow
{
    /**
     * @return int
     */
    public function startRow(): int
    {
        return 2;
    }
}

Another option would be to use HeadingRow https://docs.laravel-excel.com/3.1/imports/heading-row.html

answered Jun 23 '19 at 22:58

Robbin Benard

1,542
11
15

It doesn't work for me. It still return from the first row. – ExpertWeblancer Apr 19 '21 at 16:38
@ExpertWeblancer Update Version 3. use headingRow() – Tammam Sep 13 '21 at 07:43

score 1 · Answer 2 · answered Oct 25 '19 at 00:48

Add this code before load the Excel file. it works for me.

config(['excel.import.startRow' => your_number_of_row_to_skip]);

Ex:

$path = $request->file('select_file')->getRealPath();
config(['excel.import.startRow' => 4]);
$data = Excel::load($path)->get();

score 0 · Answer 3 · answered Jun 22 '22 at 05:20

Use setter function like this in your controller

public function voter_import(Request $request)
{
    if (empty($request->file('file')->getRealPath())) 
    {
        return back()->with('success','No file selected');
    }
    else 
    {
        $import = new VotersImport();
        $import->setStartRow(2);
        Excel::import($import, $request->file('file');
        return response('Import Successful, Please Refresh Page');
    }
}

In VotersImport class add setter function and concern WithStartRow

private $setStartRow = 1;
   
public function setStartRow($setStartRow){
     $this->setStartRow = $setStartRow;
}

public function startRow() : int{
     return $setStartRow;
}

score 0 · Answer 4 · answered Nov 15 '22 at 21:11

The Correct Use of code for comment of Tushar

Use $this->setStartRow; instead $setStartRow; in return

Wrong:
    public function startRow() : int{
         return $setStartRow;
    }

Correct:
    public function startRow() : int{
         return $this->setStartRow;
    }

score 0 · Answer 5 · edited Jun 13 '23 at 00:52

0

Just add WithHeadingRow in the implementation.

use Maatwebsite\Excel\Concerns\WithHeadingRow;

class VotersImport implements ToModel, WithHeadingRow

edited Jun 13 '23 at 00:52

Jeremy Caney

7,102
69
48
77

answered Jun 10 '23 at 08:26

Rushikesh

1

How to skip first row when importing file

5 Answers5

Linked