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 = $request->file('excelfile')->store('files'); 
        $path=storage_path('app').'/'.$path1;  
        /** Method 1 **/
          $data = \Excel::import(new ImportUsers,$path);  
        
    }
}


Step-8:


Imports/UserImport.php

<?php namespace App\Imports; use App\User; use Maatwebsite\Excel\Concerns\ToModel; use Maatwebsite\Excel\Concerns\WithHeadingRow; use Maatwebsite\Excel\Concerns\SkipsOnError; use Hash; class ImportUsers implements ToModel,WithHeadingRow,SkipsOnError { /** * @param array $row * * @return \Illuminate\Database\Eloquent\Model|null */ public function model(array $row) { return new User([ 'name'=>$row['name'], 'email'=>$row['email'], 'password'=>Hash::make('password') ]); } public function onError(\Throwable $error) { } }

 Step-9:

Finish

Comments

Post a Comment

Popular posts from this blog

Laravel Passpost

  Laravel passport What is Passport? APIs typically use tokens to authenticate users and do not maintain session state between requests. Laravel makes API authentication a breeze using Laravel Passport, which provides a full OAuth2 server implementation for your Laravel application development in a matter of minutes. You have to just follow a few steps to get following web services Login API Register API Details API Getting Started   Step 1: Install Package composer require laravel/passport open config/app.php file and add service provider. config / app . php 'providers' => [ Laravel \P assport \P assportServiceProvider :: class , ] , Step 2: Run Migration and Install php artisan migrate php artisan passport: install Step 3: Passport Configuration app/User.php < ? php namespace App ; use Laravel \P assport \H asApiTokens ; use Illuminate \N otifications \N otifiable ; use Illuminate \F oundation \A uth \U ser as Authenticatable ; class User extends ...
Read more

Export CSV File

step-1  composer requires maatwebsite/excel Step-2 make Database Connection step-3 make model can make any model  which data required in excel file.in my case model is Product.php step-3 config/app.php 'providers'=> [   Maatwebite\Excel\ ExcelServiceProvider :: class ] 'aliases'=> [   'Excel' =>Maatwebite\Excel\Facades\ Excel :: class ] step-4 make controller can make any model  which data required in excel file.in my case model is  ProductController.php namespace   App\Http\Controllers ; use  App\Models\ Product ; use   Excel ; use  Illuminate\Http\ Request ; use  Illuminate\Support\Facades\ Validator ; use  Maatwebsite\Excel\Concerns\ FromCollection ; class   ProductController   extends   Controller {           public   function   exportData ()     {          return   Excel :: downloa...
Read more

ANY

S = raw_input () print any ([ char . isalnum () for char in S ]) print any ([ char . isalpha () for char in S ]) print any ([ char . isdigit () for char in S ]) print any ([ char . islower () for char in S ]) print any ([ char . isupper () for char in S ]) if  __name__ ==  '__main__' :     s =  input ()     result = []      for  i  in  s:         result.append(i.isalnum())      print ( any (result))     result = []      for  i  in  s:         result.append(i.isalpha())      print ( any (result))     result =[]      for  i  in  s:         result.append(i.isdigit()) ...
Read more