Could use Datatables with the export (HTML5 export in the options when you download) extension and advanced filtering (select SearchBuilder in the options when you download, will allow you to filter the results and then export as PDF or Excel, CSV, or to Print).
Set-up has been covered, although you will have to add the above extensions to Datatables yourself (very configurable).