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

[PLP-GTR]

Since this is still showing up in search results and nobody mentioned it yet:

There is official documentation on how to keep track of the row number using the RemembersRowNumber trait:
https://docs.laravel-excel.com/3.1/imports/chunk-reading.html#keep-track-of-the-row-number

...
use Maatwebsite\Excel\Concerns\RemembersRowNumber;
...

class PizzaImport implements ToModel, WithChunkReading
{
    use RemembersRowNumber;

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

Only usage is with models, though, no collections.

[muarachmann]

Is there a way to get the same for an export? I can't find it in the docs https://docs.laravel-excel.com/3.1/exports/exportables.html

[itxshakil]

I did this and working perfectly.

class UsersImport implements ToModel
{
    private $rowNumber = 1;

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

[Beybala1]

@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 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,
        ]);
    }
}

Worked for me thank you

[snapey]

Does not work when skipEmptyRows is used. I want to feedback to the user which row they have an issue with but it gets out of sync if they have any empty rows.