How to Import Export Excel File in Laravel 8 using Maatwebsite Excel Package

DB_CONNECTION=mysql
DB_HOST=127.0.0.1
DB_PORT=3306
DB_DATABASE=laravel
DB_USERNAME=root
DB_PASSWORD=

composer require maatwebsite/excel

'providers' => [
  Maatwebsite\Excel\ExcelServiceProvider::class,
 ],  
 'aliases' => [ 
  'Excel' => Maatwebsite\Excel\Facades\Excel::class,
 ], 

php artisan vendor:publish --provider="Maatwebsite\Excel\ExcelServiceProvider"

//for import export
Route::get('/importexport',[App\Http\Controllers\ImportExportController::class, 'index']);
Route::post('/importxls',[App\Http\Controllers\ImportExportController::class, 'import_xls']);
Route::get('/exportxls',[App\Http\Controllers\ImportExportController::class, 'export_xls']);

php artisan make:import EmployeeImport --model=Employee

<?php
namespace App\Imports;
use App\Models\Employee;
use Maatwebsite\Excel\Concerns\ToModel;
use Maatwebsite\Excel\Concerns\WithHeadingRow;

class EmployeeImport implements ToModel, WithHeadingRow
{
    /**
    * @param array $row
    *
    * @return \Illuminate\Database\Eloquent\Model|null
    */
    public function model(array $row)
    {
        return new Employee([
            //
            'name'=>$row['name'],
            'age'=>$row['age'],
            'department'=>$row['department'],
        ]);
    }
}

php artisan make:export EmployeeExport --model=Employee

<?php
namespace App\Exports;
use App\Models\Employee;
use Maatwebsite\Excel\Concerns\FromCollection;

class EmployeeExport implements FromCollection
{
    /**
    * @return \Illuminate\Support\Collection
    */
    public function collection()
    {
        return Employee::all();
    }
}

php artisan make:controller ImportExportController

<?php
namespace App\Http\Controllers;
use Illuminate\Http\Request;
use App\Models\Employee;
use App\Exports\EmployeeExport;
use App\Imports\EmployeeImport;
use Maatwebsite\Excel\Facades\Excel;

class ImportExportController extends Controller
{
    //
    public function index(){

        $data = Employee::all();

    	return view('importexportxls',compact('data'));
    }

    public function import_xls(Request $request){

    	$this->validate($request, [
	      'upload_xls'  => 'required|mimes:xls,xlsx'
	     ]);
        Excel::import(new EmployeeImport,$request->file('upload_xls'));
 
            
        return redirect('importexport')->with('status', 'Imported Successfully');
    }

    public function export_xls() 
    {
        return Excel::download(new EmployeeExport, 'Employee.xlsx');
    }
}

@extends('layouts.app')
@section('content')
<div class="container">
    <div class="row justify-content-center">
        <div class="col-md-8">
            <div class="card">
                <div class="card-header"></div>

                <div class="card-body">
                    @if (session('status'))
                        <div class="alert alert-success" role="alert">
                            {{ session('status') }}
                        </div>
                    @endif
                    <h3>Import Excel / xls / xlsx</h3>
           <form method="POST" action="/importxls" enctype="multipart/form-data">
                @csrf
                  <div class="form-group row">
                    <label for="Payslip" class="col-md-4 col-form-label text-md-right"><b>{{ __('Excel / xls / xlsx') }}</b></label>

                    <div class="col-md-6">
                        <input type="file" class="form-control form-control-sm" name="upload_xls" onchange="readURL(this);">

                        @if ($errors->has('upload_xls'))
                            <span class="invalid-feedback" role="alert">
                                <strong>{{ $errors->first('upload_payslip') }}</strong>
                            </span>
                        @endif
                    </div>
                </div>
              <button type="submit" class="btn btn-success btn-block btn-sm">{{ __('Upload') }}</button>
         </form>
      <br>
      <a href="/exportxls" class="btn btn-info btn-sm" style="color: white;">Export</a><br><br>
                   <div class="table-responsive">
                        <table id="example6" class="table table-bordered table-hover">
                          <thead>
                               <tr>
                                   <th>SL No.</th>
                                   <th>Name</th>
                                   <th>Age</th>
                                   <th>Department</th>
                                </tr>
                           </thead>
                          <tbody>
                         @foreach($data as $key=>$value)
                            <tr>
                              <td>{{$key+1}}</td>
                              <td>{{$value->name}}</td>
                              <td>{{$value->age}}</td>
                              <td>{{$value->department}}</td>
                            </tr>  
                         @endforeach
                       </tbody>
                   </table>
                 </div>
                </div>
              </div>
            </div>
        </div>
    </div>
@endsection

php artisan serve

http://127.0.0.1:8000/importexport