combine table tool and colvis

szd

can i combine these two
dom : 'lBfrtip',
buttons: ['copy', 'csv', 'excel', 'pdf', 'print' ],

and

dom: 'Bfrtip',
buttons: [
{
extend: 'print',
exportOptions: {
columns: ':visible'
}
},
'colvis'
],
columnDefs: [ {
targets: 0,
visible: true
} ]

i want to write something like this so i can choose the column that i want to appear when download the data to excel or pdf

dom: 'Bfrtip',
buttons: [
{
extend: 'copy', 'csv', 'excel', 'pdf', 'print'
exportOptions: {
columns: ':visible'
}
},
'colvis'
],
columnDefs: [ {
targets: 0,
visible: true
} ]

szd

i think this is how we write it

 buttons: [
        {
            extend: 'copy',
            exportOptions: {columns: ':visible'}

        },
        {
            extend: 'print',
            exportOptions: {columns: ':visible'}

        },
        {
            extend: 'csv',
            exportOptions: {columns: ':visible'}

        },
        {
            extend: 'excel',
            exportOptions: {columns: ':visible'}

        },
        {
            extend: 'pdf',
            exportOptions: {columns: ':visible'}

        },
        'colvis'
    ]

allan

Yes, that looks like it should work. Are you happy with that working and you understand why it works?

Allan

szd

yes of course, knowing that i've been working on it since two days but it's easy to understand and very nice
and thank you for your reply