Search

extension: '.xlsx', fieldBoundary: "", exportOptions: { columns: [ 0, ':visible' ] } }, please help

remove or add the columns from the DOM as

I thought I had to send as fields and then set them as visible = false so that they are diponibles as data. Please, How can I send associated data to a table but are not columns? Thanks in advance

that will hide the columns that would trigger scrolling.

You can control which columns are included in the exported data using the export options as shown in this example. Allan

Have your tried to adjust() the columns? I needed to do that when columns were originally hidden or changed size between the time they were added to the dom vs when they were finally rendered. $.fn.dataTable.tables({visible:true, api:true}).columns.adjust();

28 of the 83 columns, so that will hurt

used $.getJson() to load columns and data but my

You could assign a class name to the columns you don't want to include and then do columns: ':not(".dontInclude"). There is no way to do an exclude with indexes though. Allan

the table has three columns: item, qty and price.