jQuery plugin for Excel like filter functionality [closed]

Closed. This question does not meet Stack Overflow guidelines. It is not currently accepting answers.

---

We don’t allow questions seeking recommendations for books, tools, software libraries, and more. You can edit the question so it can be answered with facts and citations.

Closed 5 years ago.

Improve this question

I need to implement a feature that would allow users to filter table data in Excel like style, i.e. dropdown menu in column headers with list of checkboxes or checkboxes grouped hierarchicaly. For instance for date column I would like to show treeview with year as root node, then month when year node expands and day on the last level. All that with checkboxes so that users can select several values.

I've looked around a bit and all existing plugins do pretty basic filtering - ascending/descending or freetext search. I have tried to extend 'dropdownchecklist' plugin but came to a point开发者_高级运维 when it seemed easier to write new plugin from scratch.

Any tips or ideas are appriciated!

---

The closest I can find is jqGrid with an integrated search toolbar which sort of acts like a filter.

Have a look here: http://trirand.com/blog/jqgrid/jqgrid.html

You'll need to expand 'New in Version 3.5' under items and then click on 'Integrated Search Toolbar' to see the demo.

There is a non-jQuery library called ExtJS that has many components, grids being one of their main ones, that definitely does it like Excel: http://dev.sencha.com/deploy/dev/examples/grid-filtering/grid-filter-local.html

If the Grid is a major part of your application and you need this excel like functionality maybe consider using ExtJS. You can use jQuery alongside it too, although it does have some core features that do similar things to jQuery.