Downloading MySQL Data To Excel

[tomyknoker]

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]

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]

http://www.dynamicdrive.com/forums/s...ad.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]

is there any measure to convert excel Data to MySQL??

[djr33]

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.