Search

button to sort my columns before exporting: { extend: 'excel',

How are you selecting the columns? One simply way would be to use a columns selected and have it match the class name of the selected columns. Allan

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

out why: extend: 'colvis', columns: ':not(.control):not(.select-checkbox)' wasn't working, while:

Hello, what is table in this line: var data = table.row(i).data(); ? edit: nevermind, I accessed the row via rows as per example https://datatables.net/examples/advanced_init/row_grouping.html besides, I need grouping by multiple columns, not just displaying another column.

Ajax Request failing for more than 8 data columns. throws 400 Bad request if one single column data is added more.

function to decorate the columns. Here I am populating

The column-selector documentation details all the selector options available for columns. The easiest would be just to have an array of column indexes. Allan

issue is that your columns array needs to be

Hi, Can this code work directly or I need to use specific syntax? Cause it's not displaying a button even if change the 0 to other value... table.button().add( 0, { extend: 'colvis', collectionLayout: 'two-column', columns: ':visible', } );