Help exporting mysql data to spreadsheet excel
Moderator: General Moderators
Help exporting mysql data to spreadsheet excel
Does anyone know how to export mysql data into a excel spread sheet or know of a tutorial???
Re: Help exporting mysql data to spreadsheet excel
you can do it with fputcsv - see here http://uk2.php.net/manual/en/function.fputcsv.php
Re: Help exporting mysql data to spreadsheet excel
the site is not working is there another one you know of?
- Christopher
- Site Administrator
- Posts: 13596
- Joined: Wed Aug 25, 2004 7:54 pm
- Location: New York, NY, US
Re: Help exporting mysql data to spreadsheet excel
Probably the easiest is to just generate CSV data and give it the Excel MIME type using header(). The browser will use Excel to open it and it will usually import automatically. There are some Excel libraries for PHP that generate the actual Excel file format. Search...
(#10850)
-
Mark Baker
- Forum Regular
- Posts: 710
- Joined: Thu Oct 30, 2008 6:24 pm
Re: Help exporting mysql data to spreadsheet excel
If you want a real Excel file rather than just a CSV, then try PHPExcel