Laravel 4 Excel import fails

Question

I'm trying to import excel files but it always give me this error:

PHPExcel_Exception
Row 2 is out of range (2 - 1)

I'm using Laravel 4 and here's my code:

public function postExcel()
{
    $file = Input::file('file');

    $destinationPath = public_path() .'/uploads/temp/';
    $filename   = str_replace(' ', '_', $file->getClientOriginalName());
    $file->move($destinationPath, $filename);

    $result = Excel::selectSheets('Sheet1')->load($destinationPath)->get();

    echo "<pre>";
    var_dump($result->toArray());
    exit;

}

This is my dummy excel file:

I've tried to google this but for other it seems like it only occurs when the sheet is more than one, but it's not like that in my case.

Also, you appear to be load()ing the public/uploads/temp folder, not the individual file. — ceejayoz
– ceejayoz, Commented Jul 15, 2015 at 3:36
the $result = Excel::selectSheets('Sheet1')->load($destinationPath)->get(); line... when I change it to: $result = Excel::selectSheetsByIndex(0)->load($destinationPath, function($reader) { $reader->noHeading(); })->get(); it gives no error but it returns null array... is it the excel file problem? — IkouKuhn
– IkouKuhn, Commented Jul 15, 2015 at 3:37
I'm not familiar with the library, but it seems weird to selectSheets() before you load() the file, and I'd guess you should be doing load($destinationPath . $filename) for starters. — ceejayoz
– ceejayoz, Commented Jul 15, 2015 at 3:39
Oh my bad! sorry, i forgot to add the filename, now it works! thanks a bunch! — IkouKuhn
– IkouKuhn, Commented Jul 15, 2015 at 3:40

ceejayoz · Accepted Answer · 2015-07-15 03:59:21Z

1

You need to load($destinationPath . $filename), not load($destinationPath) - the directory isn't an Excel file. :-)

answered Jul 15, 2015 at 3:59

ceejayoz

181k42 gold badges311 silver badges382 bronze badges

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

Collectives™ on Stack Overflow

Laravel 4 Excel import fails

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related