Laravel 8 Remove/Hide Columns While Export Data In Datatables

• In this small tutorial we will see how to Remove/Hide Columns While Export Data In Datatables in laravel 8.
• When we are using jquery datatable for displaying data in datatable and export datatabel information into PDF, Excel or CSV we might be exclude or hide some columns.
• So, In this I will give you demo how to remove/hide columns while export Data In datatables in laravel 8 using jquery.
• In this example the copy button will export column index 1 and all visible columns, the Excel button will export only the visible columns and the PDF button will export column indexes 1, 2 and 4 only and other datatable hide column.
• Column visibility controls are also included so you can change the columns easily and see the effect of the export options.

$(document).ready(function() {
    $('#demo').DataTable( {
        dom: 'Bfrtip',
        buttons: [
            {
                extend: 'copyHtml5',
                exportOptions: {
                    columns: [ 1, ':visible' ]
                }
            },
            {
                extend: 'excelHtml5',
                exportOptions: {
                    columns: ':visible'
                }
            },
            {
                extend: 'pdfHtml5',
                exportOptions: {
                    columns: [ 1, 2, 4 ]
                }
            },
            'colvis'
        ]
    } );
} );

Read Also : Laravel 8 Yajra Datatable Example Tutorial

Laravel 8 CRUD Operation Example

Export Buttons In Datatable

Thanks For Reading !!