Return Post::query()->select('id', 'title', 'body')->whereYear('created_at', $this->year) In the above example if you see we are getting records exported successfully but without column headings, if you want to add headings then you need to update PostsExport class little bit more, to implement WithHeading interface as showing below: year = $year Now you can go ahead and reload project and click on Export link, you should get excel spreadsheet downloaded into your system called posts.xlsx or xls depending on your chosen link. Schema::create('posts', function (Blueprint $table) ', open file and update export links to reference above route: Export to. Next open create_posts_table migration file to add table columns You should see message as showing below: Model created successfully.Ĭreated Migration: 2018_08_07_143410_create_posts_table Open your terminal/command prompt and navigate to project directory and execute following command $ php artisan make:model Post -m Next we are going to generate Laravel Eloquent model and database migration file to create new database table, using php artisan commands.

Database Migration and Load Test Records Create Migration and Model: env file for database connectivity settings as showing below. Now go ahead and open your project into your favourite code editor and update. Open MySql and create new database for this tutorial. OR using composer: $ composer create-project -prefer-dist laravel/laravel project-name '5.6.*' Database Settings Create New Project: $ laravel new project-name You can skip this step if you already have your Laravel project up and running. After reading this article you will find simple way to implement this feature into your Laravel project.īefore going to start working on the solution you need to have a Laravel project ready, you can also use your existing Laravel project.

Wmma 5 export to spreadsheet