When I filter my grid and see the filtered results I try to export it to Excel and get all of the data instead of filtered data. I've used the same code that is in the Excel export example.
Setting this config will enable to export only filtered rows of grid.
In case of any further query, let me know.
$opt["export"]["range"] = "filtered";
is it possible that filtered export to excel is only possible if you use database query option instead of array option to fill the grid ?
Cederic Van Herreweghe
Filter with local array is not supported.
It has some implementation issues, as local array is never back sent to server, and php does not know what you actually filtered.
Alternate, which is not very efficient … You can manage similar result by creating temporary tables by loading array in temp table and do operations.
We are sorry that this post was not useful for you!
Let us improve this post!
Tell us how we can improve this post?