exportOptions - columns

user3770935

I am using columns to list my included columns in export:

{
    extend: 'excel',
    text: 'Download Excel',
    exportOptions: {
        columns: [1,2,3,4,5,6,7,8,9,10,11,12,13,14,15],
        modifier: {
            selected: true
        }
    }
}

Instead of listing all columns to include, can I instead specify the one column to exclude?

allan

You could use a jQuery selector: :not(:eq(9)).

Allan

user3770935

Cheers Allan, perfect