Import and export data in Laravel || maatwebsite || Laravel tutorial for beginners

In this video we will see how we can import and export data in CSV and Excel file in Laravel using maatwebsite.

#excel #laravel

[CODINGISEASY]

*Thanks for a great tutorial.* I was going to cover this topic on my channel but you have it covered!

[jasonannand]

Hi

thanks for the great tutorial

what would I do if I wanted to import multiple csv files to separate database tables and the how would I export those tables to a JSOn file?

I am a bit confused on this

any help would be great

thanks

[abdulshakoorprogrammer]

thanks a ton you are best
I have spent 3 days and found this video, good explanation

[sselekane]

thanks for this needed something similar...

[agamurat]

in my project passport_issue_date is column is optional so when i export to excel it shows 01.01.1970 i want it to be empty how do i handle that?

[cyrillehounvio]

Thanks for a great tutorial but my database return empty value. Please help!

[sona]

I am using Laravel 5.2 and maatwebsite/excel 2.1, the issue is border line is not showing after setting background color, I have used the below code.
. .
$excel->getActiveSheet()->getHighestRow(), 'thin');
This code is working fine in one production but not in another one. What could be the reason for this issue?

[IrrasFamily]

Hello ! i used 3.1 version it show this error: Call to undefined method

[xzsujfu]

How can I solve the problem?
The following is an error message
Undefined offset: 1

[ztouoiu]

How can I solve the problem?
The following is an error message
Call to undefined method