How to export database table to excel file in laravel

Hi,

I use this package and it works perfectly.

It seems like you are trying to use the facade: https://docs.laravel-excel.com/3.1/architecture/#facade but that still requires you to call an exporter class that you need to create:

Try to follow this quick start guide: https://docs.laravel-excel.com/3.1/exports/

Create an export class in app/Exports You may do this by using the make:export command.

php artisan make:export UsersExport --model=User

The file can be found in app/Exports:

.
├── app
│   ├── Exports
│   │   ├── UsersExport.php
│ 
└── composer.json

If you prefer to create the export manually, you can create the following in app/Exports:

<?php

namespace App\Exports;

use App\User;
use Maatwebsite\Excel\Concerns\FromCollection;

class UsersExport implements FromCollection
{
    public function collection()
    {
        return User::all();
    }
}

In your controller you can call this export now:

use App\Exports\UsersExport;
use Maatwebsite\Excel\Facades\Excel;
use App\Http\Controllers\Controller;

class UsersController extends Controller 
{
    public function export() 
    {
        return Excel::download(new UsersExport, 'users.xlsx');
    }
}

Find your users.xlsx in your downloads folder!

Hope it will help you!

@AURAWINDSURFING - Hello my friend!

I followed this: https://docs.laravel-excel.com/3.1/getting-started/installation.html and this: https://docs.laravel-excel.com/3.1/exports/

The result is this error Symfony \ Component \ HttpKernel \ Exception \ MethodNotAllowedHttpException Can it be fixed?

It looks like that your <form> doesn't provide the correct method to reach the controller. First of all, it looks like a simple GET request to me and it would be a normal link; no form required.

What happens when you type in the URL directly into the addresbar of your browser?

@KONRMS - as @jorickl said - first establish if your export works if your form works separately. Just make a test route to controller method and see it the export part works.

@JORICKL - Hi Jorickl and @aurawindsurfing !

I replaced post with get at my web.php as below.

Route::get('/exagogi', 'FormalController@exporting');

When testing this case, I get error too as below (even if I directly enter http://laravel.site/exagogi: into browser line).

C:\xampp\htdocs\laravel\app\Exports\FormalExport.php
<?php
 
namespace App\Exports;
 
use App\formal;
use Maatwebsite\Excel\Concerns\FromCollection;
 
class FormalExport implements FromCollection
{
    /**
    * @return \Illuminate\Support\Collection
    */
    public function collection()
    {
        return formal::all();
    }
}
 
Arguments
"Class 'App\formal' not found"

My FormalController.php is the following. If I uncomment return ('Hello'); line and comment return Excel::download(new FormalExport, 'formal.xlsx'); I get Hello message as expected.

<?php namespace App\Http\Controllers;

use App\Exports\FormalExport;
use Maatwebsite\Excel\Facades\Excel;
use App\Http\Controllers\Controller;
use Illuminate\Http\Request; 



class FormalController extends Controller
    {
        public function exporting() 
        {
            //return ('Hello!');
        return Excel::download(new FormalExport, 'formal.xlsx');
        }
    }       

Please be consistent with lower- and uppercase. Classnames should be CamelCase and thus have a Capital letter at the beginning. Fix that, make sure you've imported the (right) classes and try again.

@JORICKL - For being on the safe side, I renamed formal table to users table in my database and query and retested everything. Now when pressing the export to excel button I get an empty page. I searched my pc for the users.xlsx file (which was supposed to be created in my downloads folder) but nothing was found anywhere.

I followed these two guides step by step: https://docs.laravel-excel.com/3.1/getting-started/installation.html https://docs.laravel-excel.com/3.1/exports/.

Could you help me with my code please? I have all necessary items below.

The blade excerpt is below:

<form action='/exagogi'>
    <input type="submit" value="Export to excel" />
</form>

My web.php excerpt is this:

Route::get('/exagogi', 'UsersController@export');

My whole UsersController is this:

<?php namespace App\Http\Controllers;

use App\Exports\UsersExport;
use Maatwebsite\Excel\Facades\Excel;
use App\Http\Controllers\Controller;


class UsersController extends Controller
{
        
    public function export()
    {
        //return ('Trying to add export to excel function!');
        Excel::download(new UsersExport, 'users.xlsx');
    }
    
}       

and my app\Exports\UsersExport is below:

<?php

namespace App\Exports;

use App\User;
use Maatwebsite\Excel\Concerns\FromCollection;

class UsersExport implements FromCollection
{
    /**
    * @return \Illuminate\Support\Collection
    */
    public function collection()
    {
        return User::all();
    }
}

Well, first of all, you're not returning anything in UsersController export() method. Try to find out the source. What happens if you dd(new UsersExport); in your export method? Does it initiate a new UsersExport class? And what happens if you dd((new UsersExport)->collection);? Does it return an Eloquent Collection with all users? And if nothing is working, just die('Export Method on UsersController called'); on the export method to literally see the methods fail...

Apparantly, the missing 'method="GET"' on your form is OK, because it reaches the UsersController, I suppose?

For what I can see now, it should work OK...

@JORICKL - Thank you very much! I should also thank @aurawindsurfing too.

Well I just managed to export to excel! After many many tests and failures.

But there is one thing left... I want my exported excel to have title in every table field on top and not only the table data copied into sheet. Any idea is very welcome!

For your info, my code is the following (for the whole solution, of course there should be applied these prerequisites too https://docs.laravel-excel.com/3.1/exports/).

https://docs.laravel-excel.com/3.1/getting-started/installation.html :

1. web.php:

Route::get('/exagogi','UsersController@export');

1. UsersExport.php (App\Exports\UsersExport.php)

<?php

namespace App\Exports;

use App\User;
use Maatwebsite\Excel\Concerns\FromCollection;

class UsersExport implements FromCollection
{
    /**
    * @return \Illuminate\Support\Collection
    */
    public function collection()
    {
        return User::all();
    }
}

1. UsersController.php

<?php namespace App\Http\Controllers;

use App\Exports\UsersExport;
use Maatwebsite\Excel\Facades\Excel;
use App\Http\Controllers\Controller;
use Illuminate\Support\Facades\DB;

class UsersController extends Controller 
{
    public function export() 
    {
        return Excel::download(new UsersExport, 'users.xlsx');
    }
}

Guys, I did it on the whole. So the total solution is below:

1. web.php

Route::get('/exagogi','UsersController@export');

1. UsersExport.php (App\Exports\UsersExport.php)

<?php

namespace App\Exports;

use App\User;
use Maatwebsite\Excel\Concerns\FromCollection;
use Maatwebsite\Excel\Concerns\WithHeadings; 

class UsersExport implements FromCollection, WithHeadings
{
    /**
    * @return \Illuminate\Support\Collection
    */
    public function collection()
    {
        return User::all();
    }

    public function headings(): array
    {
        return [
            'Category',
            'Title',
            'Department'
        // etc


        ];
    }
}

1. UsersController.php

<?php namespace App\Http\Controllers;

use App\Exports\UsersExport;
use Maatwebsite\Excel\Facades\Excel;
use App\Http\Controllers\Controller;
use Illuminate\Support\Facades\DB;

class UsersController extends Controller 
{
    public function export() 
    {
        return Excel::download(new UsersExport, 'result.xlsx');
    }
}

@konrms Glad to see you've fixed it! Happy exporting!

@JORICKL - Thanks a lot!

Well done!

How to implement with download batch parameter?