SpreadJS supports row filtering. You can hide rows when filtering.
For more information, see Using Row Filtering.