|No such thing as a small change|
|( #3333=superdoc: print w/replies, xml )||Need Help??|
Hi Raj. This is possibly Off-Topic, but here goes!
I was successfully able to serve up dynamic Excel files via the Apache Web Server to a web browser about a year ago. I went digging up through my file system and found this snippet. This is meant for a *NIX box, by the way - this might cause a problem when trying to write the temporary file on Win32 boxes.
If the user's Win32 box has Excel installed, Internet Explorer will use OLE to display the spreadsheet right in the browser. A catch is that the .cgi extension will confuse non-savvy users who don't know to save the file with a .xls extension instead. But ...
A really nice feature of the Apache web server is being able to specify your own extensions for CGI scripts. By adding this line to your <Directory> directive:
AddHandler cgi-script .xlsNow the Excel file can be saved 'as-is' without having to worry about getting the extension right.
L-LL-L--L-LL-L--L-LL-L-- -R--R-RR-R--R-RR-R--R-RR B--B--B--B--B--B--B--B-- H---H---H---H---H---H--- (the triplet paradiddle with high-hat)
In reply to (jeffa) Re: Error invoking Excel through cgi