Hide rows using DataTables API
Hide rows using DataTables API
ihouse85
Posts: 1Questions: 1Answers: 0
I was able to figure out how to hide the rows I wanted using JQuery. I have a modal that pops out for the user unselects the checkbox on what rows they want to hide. It works perfectly but when I export it to excel it still displays the rows hidden. I am not using the API at all and I think that's my problem. I am hiding the rows by using .show() and .hide(). I am using the API to hide the columns and when I click my export to excel button it works just fine. Could anyone help me figure out how to hide rows and be able to export it to excel with the rows not showing on the spreadsheet?
Thank you!
This discussion has been closed.
Answers
You have to use filtering in DataTables to remove rows from the display. Details on custom search plug-ins is available here.
Allan