How to export XLSX with only visible columns?

SickPuP

I am using the colvis and excel buttons for my DataTable. The excel file works fine and the column visibility is working fine. However, when I hide a couple columns and try to export those columns still appear in the output file. I only want to export columns that are visible. Any ideas?

F12Magic

Hi SickPuP,
in the exportOptions you can define columns: ':visible'
More info can be found through the excelHTML5 page.

Example:

buttons: [ 
    {
        text: 'Export to XLS',
        extend: 'excelHtml5',
        exportOptions: {
            columns: ':visible'
        }
    }
]