[Resolved] Output to Excel File

rpanning

I'm trying to make a script that will output the results of a form to a Excel file. This would have to open an existing workbook and add a row to a spacific worksheet. I've looked at several other scripts and what not but non of them are exactly what I need. So, I'm wandering if anyone knows of a good tutorial about this or good info. Any help would be great. Thanks

doobster

Here is a link to a search on Hotscripts with Excel in PHP:

http://www.hotscripts.com/cgi-bin/search.cgi?bool=AND&query=excel&catid=2

Scroll down and there are some scripts that output to Excel files.

rpanning

Thanks for the suggestion doobster, but I had already looked there. Nothing that I can find fits my needs. I've looked into the PEAR Spreadsheet_Excel_Writer package but that doesn't appear to work to well with existing workbooks. At this point I'm thinking it'll be easier to just output the results into a CSV file and import it into Excel afterwards. But if anyone still has sugestion, tutorials, whatever I'd be glad to hear them. Thanks

piersk

Sorry to say this, but when writing to excel, this is one area that ASP r00lz over PHP

*Piers prepares to be beaten

rpanning

Ya, that's kind of what I was thinking, PHP's not to Excel friendly. I was just trying to save a step by having the output go strait to an Excel file. I may have found a class which might work at phpclasses.org I'll try it out else I'll just use a CSV file. Thanks for your input.