Page 1 of 1
Help exporting mysql data to spreadsheet excel
Posted: Wed Apr 15, 2009 2:19 pm
by dynastym3
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
Posted: Wed Apr 15, 2009 2:35 pm
by deejay
Re: Help exporting mysql data to spreadsheet excel
Posted: Wed Apr 15, 2009 2:43 pm
by dynastym3
the site is not working is there another one you know of?
Re: Help exporting mysql data to spreadsheet excel
Posted: Wed Apr 15, 2009 3:13 pm
by Christopher
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...
Re: Help exporting mysql data to spreadsheet excel
Posted: Tue Apr 28, 2009 11:48 am
by Mark Baker
If you want a real Excel file rather than just a CSV, then try
PHPExcel