Posts

Showing posts from September, 2021

Laravel7 Import Data Using Excel

 Step-1: composer create-project --prefer-dist laravel/laravel blog  Step-2: composer require maatwebsite/Excel  Step-3: 'providers' => [ .... Maatwebsite\Excel\ExcelServiceProvider::class, ], 'aliases' => [ .... 'Excel' => Maatwebsite\Excel\Facades\Excel::class, ],  Step-4: php artisan vendor:publish  Step-5: php artisan make:import UsersImport --model=User Step-6 web.php Route::get('importpage','MyController@importpage'); Route::post('imported','MyController@imported');   Step-7 : Controllers\MyController.php <?php namespace App\Http\Controllers; use Illuminate\Http\Request; use Excel; use App\Imports\ImportUsers; class MyController extends Controller {     //     public function importpage()     {         return view('importdata');     }     public function imported(Request $request)     {                $path1 = $reques...