This tutorial is on “maatwebsite/excel” package that is built on top of the “phpoffice/phpspreadsheet”. In this video, you will learn how to export large data to excel, CSV in the Laravel application. We will also see, how to export model relationships with the custom query in excel and also create multiple sheets excel export using Laravel excel.

#𝟐: 𝐋𝐚𝐫𝐚𝐯𝐞𝐥 𝐄𝐱𝐜𝐞𝐥 𝐈𝐦𝐩𝐨𝐫𝐭 𝐭𝐨 𝐃𝐚𝐭𝐚𝐛𝐚𝐬𝐞 𝐰𝐢𝐭𝐡 𝐄𝐫𝐫𝐨𝐫𝐬 𝐚𝐧𝐝 𝐕𝐚𝐥𝐢𝐝𝐚𝐭𝐢𝐨𝐧 𝐇𝐚𝐧𝐝𝐥𝐢𝐧𝐠
https://www.youtube.com/watch?v=Q2AUH9w9XaA
𝐆𝐢𝐭𝐇𝐮𝐛 𝐑𝐞𝐩𝐨:
https://github.com/qirolab/laravel-excel-export-import-example
𝐋𝐚𝐫𝐚𝐯𝐞𝐥 𝐄𝐱𝐜𝐞𝐥 𝐏𝐚𝐜𝐚𝐤𝐠𝐞:
https://github.com/maatwebsite/Laravel-Excel
𝐋𝐚𝐫𝐚𝐯𝐞𝐥 𝐄𝐱𝐜𝐞𝐥 𝐓𝐮𝐭𝐨𝐫𝐢𝐚𝐥 𝐏𝐥𝐚𝐲𝐥𝐢𝐬𝐭:
https://www.youtube.com/playlist?list=PL1TrjkMQ8UbWeumS9QLpRWpkG7qIKHSqX
𝐆𝐞𝐧𝐞𝐫𝐚𝐭𝐞 𝐏𝐃𝐅 𝐟𝐫𝐨𝐦 𝐇𝐓𝐌𝐋 𝐔𝐬𝐢𝐧𝐠 𝐋𝐚𝐫𝐚𝐯𝐞𝐥 𝐒𝐧𝐚𝐩𝐩𝐲 𝐏𝐚𝐜𝐤𝐚𝐠𝐞
https://www.youtube.com/watch?v=P43fuBbmD1c
𝐄𝐱𝐩𝐨𝐫𝐭 𝐆𝐨𝐨𝐠𝐥𝐞 𝐂𝐡𝐚𝐫𝐭 𝐢𝐧 𝐏𝐃𝐅 𝐔𝐬𝐢𝐧𝐠 𝐋𝐚𝐫𝐚𝐯𝐞𝐥 𝐒𝐧𝐚𝐩𝐩𝐲 𝐏𝐚𝐜𝐤𝐚𝐠𝐞
https://www.youtube.com/watch?v=Phl26OHMs-E
00:00 Intro
00:59 maatwebsite/excel installation
01:44 artisan make:export & export users data into the excel
04:48 Exportable trait
05:30 Responsable interface
06:21 method/constructor dependency injection for Excel Class
08:19 Export formats (XLSX, XLS, CSV etc)
09:23 Export in PDF using DOMPDF
10:30 Export excel using arrays
12:55 Excel export from Laravel blade view
15:02 Auto size excel cell width
15:42 Mapping data
17:59 export data from the model relationship (for example User & Address model relationship)
22:54 add a heading row in excel
24:17 events & format cell in excel (eg: bold, border, color, etc)
27:39 export large data using FromQuery interface (Behind the scenes this query is executed in chunks).
29:28 display logo in excel sheet using WithDrawings interface
31:11 custom start cell
32:21 Laravel excel multiple sheets export example
39:55 Storing exports on disk

#laravel