Is there a way to automate MS Word/Excel using PHP/MySQL?

Question

I've just started an intranet here at the office and I would like to be able to provide some forms that my users can fill out that could then be printed as a real report that is created in MS Word or Excel - I'm using PHP/MySQL for the website

Answer 1

What I have done to allow users to work with data in Excel from PHP is create a CSL of the data for them to download and then import into the Excel spreadsheet.

Answer 2

Hello,

As far as I know, No. You could however use Sharepoint Portal Services, which is from Microsoft but costs a fee, and required windows 2000 or 2003 server to run.
That would be the easiest cookie cutter way to do what you want.

Answer 3

sure, yet another pretend myth spread round to diss Vista. i have also seen a number of references to the want to improve to place of work 2007 once you position in Vista. properly, obviously you could, regardless of the indisputable fact that that's by employing no potential a call for. place of work 2003 runs high quality on Vista. This little bit of incorrect information appears fairly many times utilized in articles that inflate the projected value to position in Vista; you could make those numbers look larger in case you upload contained in the price of upgrading place of work, too. also, opposite to the rumor that Microsoft made Vista so open source competition of its place of work products received't run on it, I had no issues in any respect setting up and operating Open place of work to open place of work 2007 information in place of work 2003, purely download a loose replace for place of work 2003 (once) to fix this problem.Then no problem. (see remark lower than) obviously a linux person who does no longer fairly understand.