Import Excel into PHP

[AndyP]

I'm just in the process of setting up an English Football Club website.

The website will carry all the usual things, which includes a league table.

We've got an Excel spreadsheet working out the league table. It works by entering the results into a grid, which then works out the league table, giving P W D L F-A Pts (home and away).

What I now need to do is to get the league table into a webpage the easiest way possible.

The website will be Content Management based.

I won't be updating the table myself, so I want to be able to set it up so that one of the club officials can enter the scores into the spreadsheet and the worksheet with the League table on will be imported into a webpage.

The club officials won't have any web knowledge.

1. Ideally I would like to be able to host the spreadsheet online, so that a number of different people can update the spreadsheet online. I then need to make it simple for them to export the spreadsheet result into the webpage.

2. Worst case scenario, would be for one person to update the spreadsheet, and then save and upload the appropriate worksheet in CSV format.

I would prefer to use option 1 if possible.

Either way, any help or suggestions would be gratefully received.


Regards

Andy

[spinal007]

Number 1 is difficult, number 2 isn't ideal.

Your best option is to re-create the functionality of the spreadsheet using a database and a few simple queries... Then it's easy to set up the CMS to enter data into the database.

[sypher]

Wouldnt it be easier to store the results in a db?

[spinal007]

great minds think alike... ... at the exact same time! LOL

[sypher]

hehe yep

[AndyP]

Originally Posted by spinal007

Number 1 is difficult, number 2 isn't ideal.

Your best option is to re-create the functionality of the spreadsheet using a database and a few simple queries... Then it's easy to set up the CMS to enter data into the database.

Thanks, that sounds promising, but I will need some help with this.

If it helps the CMS being used will be e107.

[sypher]

Ok its time to get off the CMS and start doing some original work

Your gonna need to learn php/mysql functions.

Theres loads of tutorials out there, heres just one random
http://www.phpdig.net/ref/rn41.html

[spinal007]

Yep, you're gonna need a custom made solution...
I recommend you only use other CMS as reference while you develop your own. It's the more difficult option but you'll be a better programmer and make more money in the end...

[ukgeoff]

Don't know if it's the kind of solution you are looking for but if you use this search criteria in Google;

+excel +web +conversion

you will find some useful Excel to html conversion tools.

Some of which even provide you with a web based interactive spreadsheet.

[masonbarge]

Well. to sum up:

The best way is to program a php/database page. Then all someone would have to do is pull up an online form, fill it in, and hit submit.

The easiest way on the front end is just to translate the spreadsheet to html. There are cheap commercial programs to do this ($20)-- just buy one and set it up. However, the process of editing the webpage would involve using the software, so the people editing the page are going to have to learn how to do it. I'm guessing it's not difficult.