HTML coding question

[fridaypassion]

Ok so I have a spreadsheet with several columns on it. I want to upload the spreadsheet as a table to a website but I want the columns to have the ability to be sorted by clicking on the header title. Is this possible?

Thanks!

[evenflow]

It is certainly possibly to produce this functionality.

Firstly though, when you say "upload the spreadsheet" do you mean into a database that will then be displayed via HTML? Or hard-coded into an HTML page?

If the former, then your problem becomes much easier. Have each column header as a link to the page you are on, passing a "sort by" variable. When the user clicks on the link, the page will reload, check the sort by variable and display the table in the order the user wanted.

If the latter - well, you might be able to do it with some javascript but it's a bit harder...

[fridaypassion]

I can do it whichever way Iis easiest in all honesty. Is the "sort by" variable something that I could set up in frontpage? My knowledge of HTML is quite limited as you might guess!

[BliarOut]

http://www.javascripttoolbox.com/lib/table/

That's your day's work done

[fridaypassion]

That looks like the kind of thing we're after but I'm still a wee bit confused how we get our date into it. Will give it a go!

[amir_j]

If you want to keep it very simple...

Open your spreadsheet, click 'save as' then go down to Web page. Now click on 'add interactivity' and save to your location. Voila a basic but sortable web table.

[miniman]

amir_j said:

If you want to keep it very simple...

Open your spreadsheet, click 'save as' then go down to Web page. Now click on 'add interactivity' and save to your location. Voila a basic but sortable web table.

...generated by Excel, which is the second worst thing in the world at creating HTML, the worst thing in the world being Word.

[amir_j]

miniman said:

amir_j said:

If you want to keep it very simple...

Open your spreadsheet, click 'save as' then go down to Web page. Now click on 'add interactivity' and save to your location. Voila a basic but sortable web table.

...generated by Excel, which is the second worst thing in the world at creating HTML, the worst thing in the world being Word.

As I said to keep it simple; no point over engineering.

Take an example of a corporate team leader who wants to do something quickly short term for his team to use then it is perfect.

[fridaypassion]

That might be more to my skill levels! I'll give it a try thanks a lot

[sonic_2k_uk]

miniman said:

amir_j said:

If you want to keep it very simple...

Open your spreadsheet, click 'save as' then go down to Web page. Now click on 'add interactivity' and save to your location. Voila a basic but sortable web table.

...generated by Excel, which is the second worst thing in the world at creating HTML, the worst thing in the world being Word.

I thought frontpage was the worst.

There seem to be a pattern to the software vendor here