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'
]
} );
} );

I am Laravel and PHP Developer. I have also Good Knowledge of JavaScript, jQuery, Bootstrap and REST API.