Problem with exportOptions and collapsed columns

suddaren

Hi,

I want to exclude columns from the exportoptions when exporting excel, in my case I use "noExport" as class name. This is working when I add the following exportoptions value:

exportOptions: {
columns: "thead th:not(.noExport)"
}

But this works only when the rows are visible, the problem occurs when the table rows collapse when you use a mobile device and not all the columns are visible, so it only exports the visible columns that you see. When I remove the exportOptions then ALL the columns are exported no matter if the table is collapsed or not.

I have tried the following line:

exportOptions: {
columns: [ 'thead th:not(.noExport)', ':visible', ':hidden']
}

But with no success, in this case, it exports ALL columns and also includes the noExport class columns.

Any ideas? Thanks.