I am trying to export a datatable to a excel, pdf and just to copy it. But i just want to export the selected columns from colvis. When i am exporting the table, it always shows me the full datatable. Where is my mistake?
Thx
<script type="text/javascript" language="javascript">
$(document).ready(function() {
$('#tbl').DataTable( {
dom: 'lBfrtip',
language: {
searchBuilder: {
button: 'Filter',
}
},
buttons:[
'searchBuilder',
{
extend: 'colvis',
collectionLayout: 'fixed columns',
collectionTitle: 'Spalten Auswahl'
},
{
extend: 'copy',
text: 'Copy',
exportOptions: {
modifier: {
columns: ':visible'
}
}
}, {
extend: 'excel',
text: 'Excel',
exportOptions: {
modifier: {
columns: ':visible'
}
}
}, 'pdf'
],
colReorder: true
//scrollX: true,
});
});
</script>
Instead of this:
exportOptions: {
modifier: {
columns: ':visible'
}
}
Just use this:
exportOptions: {
columns: ':visible'
}
An example is provided here: Export options - column selector. This is for the print button, but it is the same for the other buttons.
columns: The column selector to use. Default - all columns.
The modifier option is used to control something different:
modifier: How the ordering and search state of the table should be applied. Default -{search: 'applied', order: 'applied'}