Laravel How to upload EXCEL file to database?

Question

My Laravel version is 5.6.and PHP is 7. I found some upload sample on the internet, but most of them do not work. Have anyone can provide a complete example to me? I found a similar case on the Internet. Laravel 5.6 Excel and CSV import export using maatwebsite example

Unfortunately, it doesn't work, too.

Here is my source code. blade.php

<form class="form-upload" method="POST" action="{{url('/excelUpload')}}" enctype="multipart/form-data">
            {{ csrf_field() }}
             <div class="form-group">
                <label for="file">excel upload</label>
                <input type="file" id="file" name="ex_file">
                <p class="help-block">!!!</p>
             </div>
              <div class="modal-footer">
                <button type="button" class="btn btn-default">cancel</button>
                <button type="submit" class="btn btn-primary" id="upload_f">submit</button>

controller.php

public function excelUpload(Request $request){

         if($request->hasFile('StudentUploadSample')){
             return "yes i have a file";
         }
         return "nofile";
    }

However, the result always show "nofile". I didn't use any "use". Should I use something? The example on the web page does not use any "use", too. In addition, I read some of the websites that the files will be placed under the storage folder, but I can't find my file "StudentUploadSample.xlsx" in the storage folder.

Have anyone can provide a complete example to me or how to solve this problem?

it will return "nofile" because your input name is different with your request.. your input name is ex_file, but you request StudentUploadSample. It will return 'nofile' — Jay
– Jay, Commented Apr 10, 2018 at 6:45
Voting for close because it has a typo error. You should use your file name as StudentUploadSample or call hasFile on ex_file — Saad Suri
– Saad Suri, Commented Apr 10, 2018 at 6:53

dekts · Accepted Answer · 2018-04-10 06:45:41Z

3

Replace the name of file and use the reference site where you will get the proper code with explanation.

Reference site like: http://www.expertphp.in/article/laravel-5-maatwebsite-import-excel-into-db-and-export-data-into-csv-and-excel

public function importFileIntoDB(Request $request){
    if($request->hasFile('sample_file')){
        $path = $request->file('sample_file')->getRealPath();
        $data = \Excel::load($path)->get();
        if($data->count()){
            foreach ($data as $key => $value) {
                $arr[] = ['name' => $value->name, 'details' => $value->details];
            }
            if(!empty($arr)){
                \DB::table('products')->insert($arr);
                dd('Insert Record successfully.');
            }
        }
    }
    dd('Request data does not have any files to import.');      
}

answered Apr 10, 2018 at 6:45

dekts

8306 silver badges21 bronze badges

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

3 Comments

Zong Over a year ago

yes it work , and thank you. but... new issue ...... the error message show this "Call to undefined method Maatwebsite\Excel\Excel::load()"

dekts Over a year ago

Please check: stackoverflow.com/questions/49473098/…

Zong Over a year ago

Thank you very much

Pavel · Accepted Answer · 2018-04-10 06:43:48Z

1

You use the wrong name of the file in your controller:

if($request->hasFile('ex_file')){
     return "yes i have a file";
  }

So fix that, and try to check.

answered Apr 10, 2018 at 6:43

Pavel

9361 gold badge7 silver badges19 bronze badges

1 Comment

Zong Over a year ago

yes it work , and thank you. but... new issue ...... the error message show this "Call to undefined method Maatwebsite\Excel\Excel::load()" do you kbow

Chirag Patel · Accepted Answer · 2018-04-10 06:44:21Z

0

replace <input type="file" id="file" name="ex_file"> with <input type="file" id="file" name="StudentUploadSample">

and you are done.

answered Apr 10, 2018 at 6:44

Chirag Patel

1116 bronze badges

1 Comment

Zong Over a year ago

yes it work , and thank you. but... new issue ...... the error message show this "Call to undefined method Maatwebsite\Excel\Excel::load()" do you kbow

shubiao-yao · Accepted Answer · 2018-04-10 06:55:45Z

0

you can use laravel excel.

address：https://github.com/Maatwebsite/Laravel-Excel

/** * my Controller code * */

$updateFile = $request->file('update_file');

$fileSize = (int) filesize($updateFile);

$fileExtension = $updateFile->getClientOriginalExtension();

$filePath = $updateFile->getRealPath();

$excelData = Excel::load($filePath)->get()->toArray();

or you can use: https://phpspreadsheet.readthedocs.io/en/develop/

edited Apr 10, 2018 at 6:55

answered Apr 10, 2018 at 6:47

shubiao-yao

365 bronze badges

1 Comment

Zong Over a year ago

ah... i am using it

Collectives™ on Stack Overflow

Laravel How to upload EXCEL file to database?

4 Answers 4

3 Comments

1 Comment

1 Comment

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

3 Comments

1 Comment

1 Comment

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related