PDA

View Full Version : Downloading MySQL Data To Excel



tomyknoker
05-15-2007, 04:39 AM
Hi all,

Wanted some advice on downloading data from MySQL into an Excel spreadsheet... The initial site I was working with was .NET but had to be changed to PHP. When I look at the .NET example page of 'Download', click it it donwloads to an Excel spreadsheet... When I open it up it's all nicely layed out already even has the table names from the database as heading for the Excel columns...

I have been able to achieve a download of my data in a PHP page but when IT opens it's not formatted at all, and doesn't have the table names as the headings... Does anyone know if this can be done? Surely you must be able to neaten up the Excel file to some extent... I've hunted around but haven't had much luck... Any ideas would be greatly appreciated!

mhodgson
05-19-2007, 03:13 PM
Have you tried looking on th zend site. There are several examples on there of exporting from Mysql to excel using php.

http://www.zend.com/code/codex.php?id=1406&single=1

http://www.zend.com/code/codex.php?id=542&single=1

http://www.zend.com/code/codex.php?CID=323

djr33
05-20-2007, 02:21 AM
http://www.dynamicdrive.com/forums/showthread.php?t=20779
This is quite related.

Though, if those links work, it seems someone has found a way to create the excel format.

IISWILL
05-21-2007, 06:26 AM
is there any measure to convert excel Data to MySQL??

djr33
05-21-2007, 09:41 AM
I'd suggest exporting to a simple format you can later access.
I think excel can export csv, and that should work for input into mysql, with a bit of work.