It's pretty easy to export to Excel and import from Excel, with great Laravel Excel package.
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, formulas etc.
- How to process large files
- How to catch exceptions and validate import data
I will try to answer these (and more) questions in this course, in 22 video lessons.
Also, we will touch a few other tools like Google Sheets and Report Generator package.
I consider myself a Laravel expert. Work with Laravel around 6 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...
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)