Search

outside of the DataTables $columns array. My goal is

I want that my users which work with datatable can show/hide some columns like this: https://www.dropbox.com/s/v80b6xpiii4i2fi/Screenshot%202016-08-16%2016.47.41.png?dl=0 How I can add feature which help users to do it?

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