Need a table that can sort, lock

Question

I need table that will be able to:

1. sort
2. lock columns
3. lock the header row
4. resize columns
5. scroll
6. if possible can add/remove columns.

Was hoping to able to do this with jquery / html5 and have all data client side - so no server requests.

I have tried:

1. http://www.datatables.net/ has no locking, resizing of columns
2. http://tablesorter.com/docs/ similarly has no locking, resizing of columns.

Answer 1

DataTable can lock columns, and there's a plugin that adds the ability to resize them. (There's no good anchor; just do an in-page search for "resize.")

Flexigrid will do everything on your list, except for the column locking.