We have made some very complex tables as part of a project to replace some excel spreadsheet. I must admit, Excel is a worthy adversary. Think of all the flexibility it provides! Functions, adding columns, merging and splitting rows, styling and more. We have replaced only a subset of this functionality.
Se a live example here:
Download the source code from: github.com/oma/table-fixed-header
And vote for the answer at stackoverflow to give it more attention, and if you like it! HTML table with fixed headers?
I hope you like it!