Filling a table on my site

[SpikeUK]

Hi,

I want to know if this is possible, please.

I have four holiday cottages, and the availability page on my site has a table, 5 columns wide and 100 rows deep. The left hand column has the dates of the next 100 Saturdays, and the other four columns are one for each of the cottages. In each cell of the main part of the table, the colour is either green for available or red for booked, and the price for the week.

I do my bookings on an Excel spreadsheet, and finish up with a table exactly as above.

What I would like to do is upload the excel data file to my web host every day, and have a script use the data from the latest upload to populate all the cells of the table, and serve that up whenever anyone visits the availability page of my site.

Is this possible, and how can it be done? I'm afraid a fair bit of hand-holding may be necessary. I have read right through a php book I was recommended, and whilst I have learned a lot about php, it didn't deal with the angle I am aiming for.

many thanks

Spike

[subwayman]

Yes its possible but there is a simpler solution. Save your spreadsheet as HTML and upload that. You don't then need a script - simply serve the html version of your sheet.

Sometimes we over complicate things. Always try and keep it simple.