Can rows and columns be combined in export options and for selected rows only?

mhja

Managed to get only visible rows exported using the following

    "buttons": [
        {
            extend: 'copyHtml5',
            exportOptions: {
                rows: [ 0, ':visible' ]
            }
        },
        {
            extend: 'excelHtml5',
            exportOptions: {
                rows: [ 0, ':visible' ]
            }
        }   
    ]

Questions:
1) Can rows and columns be combined so that only defined columns of visible rows are exported?

colin

With columns, that can be made invisible with column().visible() - there isn't an API call to make rows (in)visible, so that wouldn't be the case here.

If you've used some other method to hide them, you can pass a function into that row-selector (where ':visible' currently is) that uses logic to check for the row's visibility,

Colin