Excel data on a web page

[Rynman47]

Hi guys

I want a section of my web page to be easily updated. It's a sporting team and I'd like to be able to update each week:

Location of next games for all teams
Times of games
Current Standings
Past week's scores

Naturally all of these things change from week to week. For multiple teams, it can be a hassle to have to update the html each week and re-upload that file.

Ideally I'd like to have it all in one or a few spreadsheets, and just upload the spreadsheet to the server, and have have the HTML document pull the data from there. Can anyone suggest how to do this?

[bill]

Excel will generate a web page version of any given spreadsheet. I've used them for a few reports that are updated regularly. They work very well on an IIS server. I haven't tried on anything else, but it should work in a similar manner on Apache.

The HTML generated by Excel is not pretty. However, it works in most browsers.

[Rynman47]

Thanks Bill.

I actually just kinda need the Excel document on the server to act as a reference for the browser to pull the data from. Don't really want Excel to generate any HTML or anything....is that possible?

[Marshall]

It seems to me you are going to have to create a database and script to pull the information. IMHO, that is the easiest solution.

Marshall

[Rynman47]

A one table database with one Field?

[Marshall]

I would think at least four fields with what you said before:

Location of next games for all teams
Times of games
Current Standings
Past week's scores

If you do a web search for database driven pages, you may find a php or asp script that uses MySQL, Access or even a flat file. Personally, I would not use Excel. Your other choice is XML which, depending on how large you file may be, works well with an XSLT file to do the layout. I use this on a lot of sites with .asp pages with files running as long as 10,000 lines without any problems. The other thing I like about it is, which a few additional tags, it can easily be used for an RSS feed. If you are not familiar with XML, you can learn the basic on W3 Schools XML Tutorial [w3schools.com].

Marshall