Excel Export/Import with Laravel
"Blind Bird" Pre-Sale: 66% off
Important: shooting videos is in progress, full course will be available in mid-December 2018. Meanwhile, for limited time, you can purchase it for early-bird price, 66% off.
Manipulating data from/to Excel is one of the most popular operations in back-end systems, built with Laravel. There is one great package called Laravel Excel, which will be shown throughout this course.
The biggest problems, however, are edge-cases and questions, like:
- How to format exported columns
- How to add header or additional columns
- How to handle date formats, character encoding, formulas etc.
- How to process large files etc.
I will try to answer these (and more) questions in this course.
Also, we will touch a few other tools like Google Sheets, Report Generator package and Datatables.
Your Instructor
I consider myself a Laravel expert. Work with Laravel around 4 years, I also write about it on my Laravel Daily Blog
Active contributor to official Laravel News blog, latest article: 20 Laravel Eloquent Tips and Tricks
Also sharing my thoughts on YouTube channel "Laravel Business": https://www.youtube.com/channel/UCTuplgOBi6tJIlesI...
Class Curriculum
-
PreviewInstallation and Simple Export from Collection (6:20)
-
PreviewExporting Table from Blade View (3:04)
-
StartExporting to Disks: Local or Amazon S3 (5:41)
-
StartExporting as CSV, HTML and PDF (3:10)
-
StartExporting into Multiple Excel Sheets (3:14)
-
StartSpecifying Heading Row(s) and Empty Columns (5:02)
-
StartCustomizing Columns and Relationships with Mapping (3:46)
-
StartFormatting, Styling and Adding Colors (4:14)
-
StartSizes of the Cells: Manual or Automatic (3:38)
-
StartSimple Import from Excel to Database via Model (3:01)
-
StartImport from XLS or CSV (1:45)
-
StartCSV Delimiters and Other Settings (4:17)
-
StartProcessing Header Row(s) (2:30)
-
Start[Coming Dec 2018] Big Files: Batches, Chunks and Queues
-
Start[Coming Dec 2018] Handling Relationships and Other Transformations