Export to Excel using PHP - Pls Help

[rosy]

Hi,
I am generating a financial report using PHP. I would like to export the report, to Excel spread sheet by clicking a button.
How do i need to do this using PHP. Please help.
Thanks.

[Chemist]

Hello,

I use the PEAR package Spreadsheet_Excel_Writer . Your button will submit a form which
calls a script that uses Spreadsheet_Excel_Writer. See this page for details

http://www.spiration.co.uk/post/1198

Good Luck,
Don

[ahundiak]

Excel 2003 has a new output format called "XML Spreadsheet". I have had pretty good luck with generating this xml with PHP and then opening it up using excel. It's basically just using a template to generate "XML Spreadsheet" data instead of HTML.

I have also uses the PEAR package but by going through XML you avoid all the binary file format issues.