html working with excel interactively

[Jammode]

I want to create a webpage that reads from an excel spreadsheet with a macro. Whats the easiest way to do this?

basically, I am running an online survey. i want to put the results of the survey into an excel spreadsheet where I will write a macro to calculate the percentage of each of the responses, and then provide this information on a webpage for people to see.

Any thoughts. Should I just use a database to collect and calculate the results.

[felgall]

You will need a server side language that understands Excel in order to do that (eg. ASP or .NET)

[Jammode]

I am using PHP also. Not sure what command though would allow excel to be used. Can it be done with PHP, or do I need to write it in ASP?

[kiwibrit]

It can be done in php - to a CSV file, at least.