In this example we will discuss about import excel file In laravel framework PHP.
Follow the below step to import :
composer require maatwebsite/excel
You may visit https://packagist.org/packages/maatwebsite/excel for more details.
'providers' => [
/*
* Laravel Framework Service Providers...
*/
......,
......,
Maatwebsite\Excel\ExcelServiceProvider::class,
]
'aliases' => [
.......,
-------,
'Excel' => Maatwebsite\Excel\Facades\Excel::class,
]
php artisan vendor:publish
/*Excel import export*/
Route::get('export', 'ImportExportController@export')->name('export');
Route::get('importExportView', 'ImportExportController@importExportView');
Route::post('import', 'ImportExportController@import')->name('import');
Note: This command avaialble only if you download dependecy successfully using composer(step 1)
php artisan make:import BulkImport --model=Bulk
<?php
namespace App\Imports;
use App\Bulk;
use Maatwebsite\Excel\Concerns\ToModel;
use Maatwebsite\Excel\Concerns\WithHeadingRow;
class BulkImport implements ToModel,WithHeadingRow
{
/**
* @param array $row
*
* @return \Illuminate\Database\Eloquent\Model|null
*/
public function model(array $row)
{
return new Bulk([
'name' => $row['name'],
'email' => $row['email'],
]);
}
}
<?php
namespace App;
use Illuminate\Database\Eloquent\Model;
class Bulk extends Model
{
protected $table = 'bulk';
protected $fillable = [
'name', 'email',
];
}
php artisan make:controller ImportExportController
<?php
namespace App\Http\Controllers;
use Illuminate\Http\Request;
use App\Exports\BulkExport;
use App\Imports\BulkImport;
use Maatwebsite\Excel\Facades\Excel;
class ImportExportController extends Controller
{
/**
*
*/
public function importExportView()
{
return view('importexport');
}
public function import()
{
Excel::import(new BulkImport,request()->file('file'));
return back();
}
}
<!DOCTYPE html>
<html>
<head>
<title>Import Export Example</title>
<link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/twitter-bootstrap/4.1.3/css/bootstrap.min.css" />
</head>
<body>
<div class="container">
<div class="card bg-light mt-3">
<div class="card-header">
Import Export Example
</div>
<div class="card-body">
<form action="{{ route('import') }}" method="POST" enctype="multipart/form-data">
{{ csrf_field() }}
<input type="file" name="file" class="form-control">
<br>
<button class="btn btn-success">Import Bulk Data</button>
<a class="btn btn-warning" href="{{ route('export') }}">Export Bulk Data</a>
</form>
</div>
</div>
</div>
</body>
</html>