Posted by Louis on 08/10/07 18:06

> If you can get directly to the database, I'd advise skipping PHP all
> together, and make an ODBC connection to MySQL, which Excel itself can
> then use as it's datasource.

I missed mentioning that the whole application starts from the web. I
have to trigger this Excel update operation through a button on the web
form.

When user clicks the button, I start a javascript function and that's
where I contemplate options of doing this. One of the options is to use
ajax request to call a php script on the server, and that's the question
I have on this newsgroup.

The other option is to run a perl script instead of php on the server to
do this. I have an example of perl script to update excel. However I
have no idea how to get apache to execute this perl code as a script
instead of a cgi script which displays the perl script code!

Thanks for your time.

[Back to original message]