How to export all records as excel using Yajra DataTable

So I'm trying to export the records as excel, but only 10 records are exported. Is it possible to export all of the records?


public function html(): HtmlBuilder
    {
        return $this->builder()
                    ->setTableId('drcsendmoneytransac-table')
                    ->columns($this->getColumns())
                    ->minifiedAjax()
                    ->stateSave(true)
                    // ->responsive()
                    ->autoWidth(false)
                    ->parameters(['scrollX' => true])
                    ->addTableClass('align-middle table-row-dashed fs-6 gy-5')
                    ->parameters([  
                        'dom'          => 'Bfrtip',  
                        'buttons'      => ['excel', 'csv', 'pdf'],  
                    ])
                    ->orderBy(0)
                    ->selectStyleSingle();
    }

EZeller1

3 years ago

Level 1

Laravel Yajra Datatables Export to Excel CSV Button Example Step 1: Install Laravel. ... Step 2 : Install Yajra Datatable. ... Step 3: Add Dummy Records. ... Step 4: Create DataTable Class. ... Step 5: Add Route. ... Step 6: Create Controller. ... Step 7: Create View. https://www.foremostpayonline.org/

Thanks,

henock_barakael

3 years ago

Level 1

@EZeller1 Already done. So I'm trying to export the records as excel, but only 10 records are exported. Is it possible to export all of the records?

Randy_Johnson

3 years ago

Level 8

@henock_barakael Create a page where all records are shown and then export.

salamaslam.official

3 years ago

Best Answer

Level 1

https://www.itsolutionstuff.com/post/laravel-yajra-datatables-export-to-excel-csv-button-exampleexample.html

Here is best explanation, if you find any issue do let me know

1 like

henock_barakael

3 years ago

Level 1

@salamaslam.official Thank you very much, I was able to solve the problem with this. By the way, I had to use the server-side export buttons https://yajrabox.com/docs/laravel-datatables/10.0/buttons-starter and load the custom scripts <script src="/vendor/datatables/buttons.server-side.js"></script>

1 like

salamaslam.official

3 years ago

Level 1

@henock_barakael i think this is required some R&D 🙂

1 like

Suhasini_R

3 years ago

Level 1

dom: 'lBrtip',

    "buttons": [{
                extend: 'excel,
                    exportOptions: {
            modifier: {
                     page: 'all'
            }
        }

this is my script for excel button but it only download 10 records not all records

Please or to participate in this conversation.