Laravel-excel: How to get current row number

[dalholm]

Prerequisites

Versions

• PHP version: 7.2
• Laravel version: 5.7
• Package version: 3.1

Description

Im using ToModel in my import and need to store the current row number.
How do i do that? :)

namespace App\Imports;

use App\User;
use Maatwebsite\Excel\Concerns\ToModel;

class UsersImport implements ToModel
{
    public function model(array $row)
    {
        return new User([
            'name' => $row[0],
            'row_number' => '?????'
        ]);
    }
}

[patrickbrouwers]

@dalholm you can keep state in your import object.

class UsersImport implements ToModel
{
    private $row = 0;

    public function model(array $row)
    {
        return new User([
            'name' => $row[0],
            'row_number' => ++$this->row,
        ]);
    }
}

[dalholm]

@patrickbrouwers so simple, worked like a charm. Thanks! 👍

[weiwait]

@dalholm you can keep state in your import object.

class UsersImport implements ToModel
{
    private $row = 0;

    public function model(array $row)
    {
        return new User([
            'name' => $row[0],
            'row_number' => ++$this->row,
        ]);
    }
}

So, how do it at chunk reading?

[benedict-w]

@weiwait yes - any way of checking the row count in a chunked import?

[weiwait]

@weiwait yes - any way of checking the row count in a chunked import?
I'm using Cache Dirve to record

current chunk