I have implemented this with PHPExcel.php http://phpexcel.codeplex.com/ >From memory, it works the same as writing an XML file, only it writes an XLS file. 2011/6/14 Arthur Cláudio de Almeida Pereira <arthur.almeidapereira@xxxxxxxxx > > > > Hi, > If you want to show a simple spreadsheet like a table in excel you > can make a html table with your records and you can change de header to > transform that html table in a excel file. > Sorry about the english, I don't know how to write very well > > regards, > > Em 14/06/2011 12:20, Tony Jones escreveu: > > > > > Is this a one time thing or do need to create a php script to allows > > users to export a file and save it as an Excel file? You can easily > > send the output of a mysql statement to an outfile and save it with > > the extension .csv and then import or open it in Excel, or you can > > save or return the output in html format. See the mysql command on how > > to this. > > > > Tony > > --- On Tue, 6/14/11, anandh Kumar <hawkeranandh@xxxxxxxxx > > <mailto:hawkeranandh%40yahoo.com>> wrote: > > > > From: anandh Kumar <hawkeranandh@xxxxxxxxx > > <mailto:hawkeranandh%40yahoo.com>> > > > Subject: MYSQL TO EXCEL > > To: php-objects@xxxxxxxxxxxxxxx > > <mailto:php-objects%40yahoogroups.com>, vijayalakshmi6jun@xxxxxxxxx > > <mailto:vijayalakshmi6jun%40gmail.com> > > > Date: Tuesday, June 14, 2011, 10:40 AM > > > > > > > > Hi To All.... > > > > can any one guide me... > > > > i need a code for mysql table record export to excel file using php > > and mysql > > > > [Non-text portions of this message have been removed] > > > > [Non-text portions of this message have been removed] > > > > > > [Non-text portions of this message have been removed] > > > -- * Ryan David Pardey * ** musician | web developer | programmer | researcher ryandpardey@xxxxxxxxx 1-323-309-7074 [Non-text portions of this message have been removed] ------------------------------------ Are you looking for a PHP job? Join the PHP Professionals directory Now! http://www.phpclasses.org/jobs/ Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/php-objects/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/php-objects/join (Yahoo! ID required) <*> To change settings via email: php-objects-digest@xxxxxxxxxxxxxxx php-objects-fullfeatured@xxxxxxxxxxxxxxx <*> To unsubscribe from this group, send an email to: php-objects-unsubscribe@xxxxxxxxxxxxxxx <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/