How to use Export buttons with serverSide and scroller

Wernfried

I use a table with

columnControl: [...]
ajax:'/api/data',
responsive: { orthogonal: 'responsive' },
serverSide: true,
scrollY: 300,
scrollCollapse: true,
scroller: true,

Is there a build-in method to control behavior of export buttons (e.g. csvHtml5, copyHtml5 or excelHtml5)
Problem is, it exports the currently loaded rows but with Scroller Extension you don't know which and how many rows are loaded exactly at the moment when you click the export button.

Of course, I could create a custom button which reads all search/order parameters from DataTable API, runs a AJAX request manually to get desired data and the export the data to desired format. Is there an easier way to control which rows get exported?

Kind Regards
Wernfried

kthorngren

See this FAQ about using the export buttons with server side processing.

Kevin