faqts : Computers : Programming : Languages : PHP : Database Backed Sites : MySQL : Questions in search of an Answer

+ Search
Add Entry AlertManage Folder Edit Entry Add page to http://del.icio.us/
Did You Find This Entry Useful?

2 of 6 people (33%) answered Yes
Recently 2 of 6 people (33%) answered Yes

Entry

hello, is there any way that i can show the content of a mysql DB into a excel file using php?

Oct 26th, 2003 13:12
Alexander Berkman, Jonathan Sharp, Cesar Martinez, Onno Benschop,


Just print out the result set as a comma deliminated list, with each 
record as a new line and then you can import it. (CSV format)
--You can also use php_writeexcel, a class based on
Spreadsheet::WriteExcel in Perl.
Download it at:
http://bettina-attack.de/jonny/view.php/projects/php_write_excel/