How to perform Excel Import Analysis

[noblemfd]

I am performing Excel file upload using PHP-7.4, Laravel-8 and Maatwebsite-3.1 package.

Import:

    private $rows = 0;

    public function onRow(Row $row)
    {
        ++$this->rows;
        $rowIndex = $row->getIndex();
        if($rowIndex >= 1000)

        $row = $row->toArray();

        $employee = Employee::create([
            'first_name'                        => $row[0],
            'other_name'                        => $row[1] ?? '',
            'last_name'                         => $row[2],
            'email'                             => preg_replace('/\s+/', '', strtolower($row[3])),
        ]);

    }

    public function startRow(): int
    {
        return 2;
    }

   public function getRowCount(): int
   {
      return $this->rows;
   }

Controller:

public function importEmployee(Request $request)
{
        $validator = Validator::make($request->all(), [
            'document' => 'file|mimes:xls,xlsx|max:5000',
        ]);

        if ($request->hasFile('document'))
        {
            if($validator->passes()) {
                $import = new EmployeeImport;
                $file = $request->file('document');
                $dataTime = date('Y-m-d H:i:s');
                $file->move(public_path('storage/file_imports/employee_imports'), $file->getClientOriginalName());
                Excel::import($import, public_path('storage/file_imports/employee_imports/' . $file->getClientOriginalName() ));

                foreach ($import->failures() as $failure) {
                    $importerror = new ImportError();
                    $importerror->data_row = $failure->row(); // row that went wrong
                    $importerror->data_attribute = $failure->attribute(); // either heading key (if using heading row concern) or column index
                    $importerror->data_errors = $failure->errors()[0]; // Actual error messages from Laravel validator
                    $importerror->data_values = json_encode($failure->values());
               }

               $successfulImports = ('Successful: ' . $import->getRowCount());

                return $this->success('Employees Successfully Imported.', [
                    'file'         => $file
                ]);
            }else{
                return $this->error($validator->errors(), 422);
            }
        }
}

How do I get the following:

1. Total Rows
2. Total successful Uploaded Rows
3. Total unsuccessful (failed) Rows

Thanks

[patrickbrouwers]

Successful rows: https://docs.laravel-excel.com/3.1/architecture/objects.html#getters
Count failed rows with import->failures().
Add the two for the total rows (or use PhpSpreadsheet to get the total row count)

[noblemfd]

@patrickbrouwers - I went through the documentation and I was able to get the count for successful uploads (see my updated code)

Can you show me using example how I can:

use PhpSpreadsheet to get the total row count ?

Thanks

[patrickbrouwers]

Please google it, it will be in their documentation.