how to upload a csv file in laravel excel 3.1 and loop results as mapped array

[ahmadhashlamoun]

I was using maatwebsite/excel v2.1, and now I'm upgrading to version 3.1

I used to loop the uploaded excel file like

Excel::selectSheetsByIndex(0)->load($destinationPath . $fileName,
      function ($reader) use (&$i, &$y) {
        $all = $reader->get();

        foreach ($all as $index => $row) {
          $city = $row->city;
}
});

But now I'm unable to do so with laravel 6 and excel 3.1, can you tell me how to do so? I know the load function is deprecated, and I need to replace it with import() but how to replace it and still access excel sheet rows with their keys and values?

[patrickbrouwers]

Please refer to this documentaiton: https://docs.laravel-excel.com/3.1/imports/collection.html

[ahmadhashlamoun]

oh I see! thanks a lot, one more thing, how would I get the count of rows for this import? Assume I'm doing the collection import via a controller and i need to return the count, what should i do?

[patrickbrouwers]

Please use the search function in the documentation: https://docs.laravel-excel.com/3.1/imports/chunk-reading.html#keep-track-of-the-row-number

When using collection, you can just use the count() or the array indices.

[ahmadhashlamoun]

I'm sorry, but how this count could be retireived in the controller after the import function?
Suppose in the controller I have this:

$propertyImport = Excel::import(new PropertyImport, $destinationPath . $fileName);
 log::debug(json_encode($propertyImport));

how would I get the count for the collection after uploading it?

[patrickbrouwers]

I'd highly recommend reading the entire documentation, especially https://docs.laravel-excel.com/3.1/architecture/objects.html we have this exact example in there.