Page 1 of 1

Exporting Data to MS Excel

Posted: Thu Jan 11, 2007 9:36 am
by iknownothing
Hey Guys,
I was wondering if were all possible (most likely with PHP) to export data from a MySQL database into an excel spreadsheet. Reason being, I am designing an accounting application, and most accountants over here (Australia) are fond of recieving financial data in Excel form...

Posted: Thu Jan 11, 2007 9:43 am
by feyd
Take a look in PEAR.

Posted: Mon Jan 15, 2007 8:18 am
by decipher
If you are not familiar with PEAR, you can save the info in a csv format you open in excel.

Take a look into the putscsv() function (PHP Ver 5)
Alternatively in conjunction with fwrite() you can build the deliminated file structure yourself quite easily.