At my workstation we have a mysql database containing customers payment information. My boss has just asked me to write a PHP application that can get data from this database and point the business analysts to save or download query results from the database in an excel format, either Excel 2003 or 2007. I have never done this task before. Searching on the web i found a tutorial that says this could be possible using a PEAR package SpreadSheetExcelWriter but generating only Excel version 5 (version of 1993), which means this PEAR version cannot help me.
Has someone done this task in the past or just point me to a good tutorial?
Thank you for your time to help.