How to Import Excel file data into database in Laravel 10 using maatwebsite/excel package w/ example

In this video, I have taught how to import excel sheet data into database in laravel 10 using maatwebsite/excel package. I have taken an example of Customer details to import data from excel sheet in database.
Also how to update the existing data into database while excel import.
Post - How to Import Excel file data into database in Laravel: www.fundaofweb...
How to create Layout using Component in Laravel 10:
• How to create Layout u...
Laravel 10 Tutorial Playlist:
• Laravel 10 Tutorial
Follow us on Instagram: / funda_of_web_it
Subscribe to my Hindi/Urdu Channel: / fundaofwebithindi

[@mirazh8216]

very informative tut. please prepare a full real world project ( task/document/project management system using laravel this is my recommendation) please please please

[@voiceofrjbilal]

Sir i got error
after i give this comand : php artisan vendor:publish --provider="Maatwebsite\Excel\ExcelServiceProvider" --tag=config
Method Illuminate\Foundation\Application::share does not exist.

[@nezseco4719]

Do you still want to know how to solve it?

[@QueenMaryem-w7e]

hi can u help me with that
@@nezseco4719

[@QueenMaryem-w7e]

did u resolve this problem because i got the same

[@nezseco4719]

@@QueenMaryem-w7e yeah i did

[@nezseco4719]

​@@QueenMaryem-w7e Yeah, I do

[@KarishmaShah-hw9qs]

Hello ,
I am getting the error undefined array key 0 in CustomerImport file. Can you let me know the issue which might have happened.

[@manishkushwaha-je6xy]

Great sir, thank you, you keep your promise 🙏

[@virenkhokhar6305]

This video is useful ❤ thankyou 🎉

[@ManishKushwaha-m5s]

Sir please create one more video how to download in excel

[@virenkhokhar6305]

Sir can you please explain the database design and its retrieve of data in blade file of attandance. The attendance of every employee and it will be shown of the whole month. Please provide a video if its possible 🙏🏻 thankyou ❤

[@Warkim]

🎉 thank you sir

[@maptoursdmcjordan6310]

how to do it direct to the host without app ? i have xls fine need to uplode it, any one can help me ?

[@forexspectrum4799]

Thanks alot sir ❤

[@user-rx8lz6yz4f]

excellent, thanks!

[@manishkushwaha-je6xy]

sir we can use the updateOrInsert method at the position of the if and else condition

[@fundaofwebit]

Yes, you can: here is a syntax with example :
Product::updateOrCreate(
[
'name' => $request->name,
],
[
'name' => $request->name,
'price' => $request->price,
]
);

[@manishkushwaha-je6xy]

@@fundaofwebit thank you very much sir

[@raveendrasothykeerththiga9231]

Amazing

[@QueenMaryem-w7e]

Method Illuminate\Foundation\Application::share does not exist.