jquery datatable export to excel exportoptions
$(document).ready(function() { $('#example').DataTable( { dom: 'Bfrtip', buttons: [ { extend: 'print', exportOptions: { columns: ':visible' } }, 'colvis' ], columnDefs: [ { targets: -1, visible: false } ] } ); } );