Convert Excel to HTML with Sort and Filter

[write2dgray]

I need to convert an Excel file to html with the ability to sort and filter the table produced. I would need this table to be viewable in Firefox and IE when loaded on a webpage.

Is there any software out there to do this or a method to add these features? An optimal solution would be one that allows me to modify/update the tables and apply to other tables without too much braindamage, i.e. export excel to html with autosort and autofilter of top row already there or add autosort and autofilter to html table.

Thanks in advance for any help!

- David

 

[jimrward]

if it is any help i did something a good few years back, to output results from a road race to HTML, where you can click on the column headers to sort by that column

the data ws extracted with a VBA macro and it contained a few lines of javascript which did the sorting along with some stylesheets, and other XML stuff

I think I still have it at home, in the mean time do a search on google for "data islands"