datatable ExportToExcel - all rows regardless of filtering

Webix JS
1

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

2

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

3

Hi Listopad,

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

Regards,
Kaleem B N

4

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

5

Hi Helga,

Thanks a lot … It worked…