Datatables export only visible columns

[g inberg]

Hi all,

in a datatable I am using the option (button) to hide certain columns in the data, since there are a lot of columns.

Now I am adding an excel export option and I would like to export only the visible columns, but it is exporting all columns.

In the javascript version of datatables it is working see https://datatables.net/extensions/buttons/examples/html5/columns.html but I don't know how to do this in shiny.

Any ideas?

best,

Ger

[g inberg]

I found it myself. For reference I used syntax like

buttons = list(list(extend = 'excel', exportOptions = list(columns = ':visible')), list(extend = 'colvis', text='Show/Hide Columns', collectionLayout='fixed four-column'))