Undefined index: description - Uploading Excel File

Question

Is there a way i can stop the reader from reading the excel file when any of the row data is different? When i upload an excel file, i get Undefined index: description which means description cannot be found in the file uploaded.

Is there a way i can just handle this error ?

if ($request->file('imported-file')) {
  $path = $request->file('imported-file')->getRealPath();

  $data = Excel::load($path, function($reader) {
     $reader->calculate(false);
  })->get();

  if (($request->file('imported-file')->getClientOriginalExtension()) != 'xlsx') {
    return redirect('')->with('error','File Format may not be supported');
  } else {

    if (!empty($data) && $data->count()) {
      foreach ($data->toArray() as $row) {
          if (!empty($row)) {
            $dataArray[] = [
              'name' => $row['name'],
              'description' => $row['description'],
            ];
          } 
      }

      if (!empty($dataArray)) {
         Item::insert($dataArray);

         return redirect('')->with('status','successfully added');  
      }
    }

  }
}

if (!$row['description']) {break;}

Tpojka
– Tpojka

2017-12-11 00:40:48 +00:00
Commented Dec 11, 2017 at 0:40 — Tpojka
– Tpojka, Commented Dec 11, 2017 at 0:40

Marcin Nabiałek · Accepted Answer · 2017-12-10 22:48:15Z

1

Instead of:

'description' => $row['description'],

you could use

'description' => array_get($row, 'description'),

answered Dec 10, 2017 at 22:48

Marcin Nabiałek

112k43 gold badges271 silver badges299 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Chandan Bisht · Accepted Answer · 2020-07-02 14:03:44Z

0

I was also facing the same issue, here is my solution, Hope it will help someone.

Note : This is for Laravel 6.0, Importer class must implements ToModel, WithHeadingRow these two interfaces,

return new Holiday([
'name'          => Arr::get($row,'name'),
'start_date'    => Arr::get($row,'start_date'),
'end_date'      => Arr::get($row,'end_date'),
]);

answered Jul 2, 2020 at 14:03

Chandan Bisht

533 bronze badges

Collectives™ on Stack Overflow

Undefined index: description - Uploading Excel File

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related