, ,

xlsTableFilter: Create an excel style filter dialog on a table containing headers

xls TableFilter is a JQuery UI plugin that create an excel style filter dialog on a table containing headers

Download: Click here

Demonstration:

Plugin homepage:

Implementation:

$("table").xlsTableFilter();

Options:

widthIntegerDefault : 400 – An integer setting the width of the filter dialog.
heightIntegerDefault : 400 – An integer setting the width of the filter dialog.
maxHeightIntegerDefault : Window height – An integer setting the maximum height of the filter dialog.
ignoreCaseBooleanDefault : true – A boolean setting whether the filter should ignore case.
checkStyleStringDefault : default – A string defining whether the dialog should use html checkboxes or custom on/off images. “default” will use html checkboxes. “custom” will use images.
ignoreColumnsArrayDefault : null – An array containing zero-based column indexes that will not have filters assigned.
onlyColumnsArrayDefault : null – An array containing zero-based column indexes that will always have filters assigned. Overrides ignoreColumns. If set, then only columns in this array will be assigned filters.
rowsDisplayStringDefault : xlsTableFilterRowsDisplay – An element to print the number of rows displayed in. If a string is specified, the element with that id will be used.

Screenshots: