How can i get the searched or filtered data from datatables on click of excel export?
How can i get the searched or filtered data from datatables on click of excel export?
![somasowmi@live.com](https://secure.gravatar.com/avatar/6e26ea138a4518221b09ca2b4462c2e5/?default=https%3A%2F%2Fvanillicon.com%2F6e26ea138a4518221b09ca2b4462c2e5_200.png&rating=g&size=120)
**Is there any way to get the searched or filtered data from data tables across the pages **on click of excel export? I need this data set to be send to my server as a json format for some reasons.
This discussion has been closed.
Answers
Hi @somasowmi@live.com ,
You can use the
rows()
, with the select-modifier of{search:'applied'}
to get the filtered data, and add that into an Ajax call in abutton-action
event.Cheers,
Colin