Search

Whats wrong with using this?? exportOptions: { columns: [1,2,3,4,5,6] }

You are setting data": "description", for columns 3, 4, 5 and 6. They will all show the description data. Do you actually need that property? Where is the data for the table coming from? Allan

You could use ColReorder which allows columns to be reordered via click and drag. Allan

class as shown below. columns: [ { data: 'Id', title: 'Id',

Super - thanks for the test case! Its being caused by the use of the class name as the selector for AutoFill columns - it gets confused! I've committed a fix. This is your example with the latest code. Allan

It typically does, although you can use the columnDefs.targets option as an array and target multiple columns with it (or a string that will target columns with a common class). Allan

NOTE: this wasn't meant as a step by step guide.... to work, you'll either have to create a view, or other columns programatically (expression) that also enables DT to search for these "Search" columns.

computer's power (processor). 200 columns is not unreasonable. Allan

So what I should do to have that styling and column visibility+ export to excel only visible columns working?

if I remove specific columns from that JSON, DataTables