Скачать или смотреть #223

This Laravel excel export video is a part of my Laravel Advance E-commerce Series
►Click here to access the complete course:    • Laravel Tutorial for Beginners | Advance E...  

In Part-223 of the Laravel E-commerce series, we will continue working on the Newsletter Subscriber feature in which users can subscribe to the website newsletter by entering their emails.

In this video, we will work on the Export feature to export the subscribers emails in CSV format that can be further used to send Newsletters emails to subscribers for offers and other updates.

We need to install maatwebsite 3.1 package for export functionality of newsletter subscribers.

1) Install Maatwebsite package 3.1 version
First of all, install maatwebsite package 3.1 version for export functionality by running below composer command :-
composer require maatwebsite/excel

2) Create subscribersExport
Now create subscribersExport class by running below artisan command :-
php artisan make:export subscribersExport

You can open subscribersExport file in which you can see the collection function automatically created that will return data from NewsletterSubscriber model.

3) Create Route :-
Now create Get route to export newsletter subscribers in web.php file like below :-
// Export Newsletter Emails Route
Route::get('export-newsletter-emails','NewsletterController@exportNewsletterEmails');

4) Update newsletter_subscribers.blade.php file :-
Now update newsletter_subscribers.blade.php file to add export newsletter subscribers link.

5) Create exportNewsletterEmails function :-
Now create exportNewsletterEmails function in NewsletterController and write code to download excel file for newsletter subscribers.

6) Add Header Statements:-
Add below statements at the top of NewsletterController to include subscribersExport that we have created and Maatwebsite class for sure.

7) Update collection function :-
Now we will update the collection function in the subscribersExport.php file to write query to select newsletters that are active only.

Maatwebsite Package 3.1 does not show column headings by default. We need to take the below steps to add headings for our excel data means the newsletter_subscribers table column names so that it will be easier to understand the data.

i) Add below header statement for headings in subscribersExport file :-
use Maatwebsite\Excel\Concerns\WithHeadings;

ii) Update subscribersExport class in subscribersExport file like below:-
class subscribersExport implements WithHeadings,FromCollection

iii) Add headings function in subscribersExport file with heading names in array as shown in the video.

This video is a part of my Laravel Advance E-commerce Series
►Click here to access the complete course:    • Laravel Tutorial for Beginners | Advance E...  

►Click here to subscribe - https://www.youtube.com/stackdevelope...

Other Popular Stack Developers Series that can help you:-

►Laravel API Tutorial -    • Laravel API Tutorial | Create API from Scr...  

►Laravel Interview Questions -    • Laravel Interview Questions & Answers | 20...  

►jQuery Tutorial -    • jQuery Tutorial  

►Laravel Basic E-commerce Series -    • Make Admin Panel / E-commerce Website in L...  

►Laravel Dating Series -    • Make Dating / Social Networking Website in...  

►GIT Tutorial for Beginners -    • Git Tutorial for Beginners | Create your F...  

Follow Stack Developers on Social Media to get updates and resolve your queries
►Like Facebook Page to get updates -   / stackdevelopers2  
►Join Facebook Group to resolve your queries -   / stackdevelopers  
►Follow on Instagram -   / stackdevelopers2  
►Follow on GitHub - https://github.com/stackdevelopers

►Join this channel to get access to perks -    / @stackdevelopers