datatable ExportToExcel - all rows regardless of filtering

Hi, I want to export to excel all rows from datatable regardless of current filtering. How to do it?

Hi,

toExcel export allows exporting the datatable with the current sorting, filters, and visible columns.

You can clear all filters and restore them after using the getState() API:

http://webix.com/snippet/74ed8317

Hi Listopad,

Is there any other way to export all rows regardless of current filtering,rather than clearing of filters ?

Regards,
Kaleem B N

Hello,

You can create a temporary data collection, parse all the datatable’s data there and export this collection:

Check the snippet, please: https://webix.com/snippet/ee28e38c

Hi Helga,

Thanks a lot … It worked…