[SOLVED] Anyone have a good tutorial or script for exporting mysql entries into excel?

[rxbanditboy1112]

I have been looking everywhere, but the scripts constantly fail. Anyone know of a good one. The one on php freaks doesn't work. I can see the thread, but I can't see the tutorial and I can't see any of the posts in the thread.

[davestewart]

It's relatively simple.

 

Excel reads .CSV files (comma separated values) so you just need to output the database results line by line, with the values separated by commas.

 

Just use a database class like ezSql to get the results from the database, then loop through them with a nested loop (one for the rows, then the nested one for the columns / vallues).

 

Any quotes need to be output as "" (2 quotes in a row)

 

Line endings should be \r\n

 

If you want to be able to click a link then have Excel want to open it as a spreadsheet, add the following header to your plain text output first:

 

$filename = "My excel file.xls";

header("Content-disposition: attachment; filename=\"$filename\"");

header("Content-type: application/vnd.ms-excel");

 

Cheers,

Dave

[rxbanditboy1112]

wow that is really easy haha, thanks a ton!

[davestewart]

No worries. Yeah - it took a while to figure it all out but easy when you know!

If you want to get into formatting Excel you need to look at the xml spreadsheet format.

Probably not worth the hassle though!