Page 1 of 1

MySQL to Excel

Posted: Tue Jan 25, 2005 12:42 pm
by Joe
Is it possible to insert data from a MySQL database into an excel spreadsheet?. If so, how?.

Thanks


Joe

Posted: Tue Jan 25, 2005 1:09 pm
by feyd
export from MySQL as CSV

Posted: Tue Jan 25, 2005 1:27 pm
by Joe
Yes I can do that, however is there a way to convert this into a .xsl (Excel) sheet using nothing but PHP?.

Posted: Tue Jan 25, 2005 1:32 pm
by feyd
you wan to write tons of binary data?

Posted: Tue Jan 25, 2005 1:41 pm
by Joe
Ehhh :? nevermind I will think of an alternative. Thanks mate!

Posted: Mon Feb 20, 2006 2:07 am
by spitfire_esquive
The PEAR Spreadsheet Excel Writer works like a dream :)

Posted: Mon Feb 20, 2006 2:16 am
by Chris Corbyn
Yeah we generate Microsoft Excel files for reporting... I believe it's a PEAR package we use :)

Posted: Mon Feb 20, 2006 2:18 am
by feyd
13 month old thread................................... :roll:

d11wtq | :oops: