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...
Exporting Data to MS Excel
Moderator: General Moderators
- iknownothing
- Forum Contributor
- Posts: 337
- Joined: Sun Dec 17, 2006 11:53 pm
- Location: Sunshine Coast, Australia
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.
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.