My requirement was to be able to save images and cell formatting (colors, fonts etc) so a CSV was not a solution for me. With PHPExcel I was able to achieve that. I can dig up some code if you want. http://phpexcel.codeplex.com On Tue, Jun 14, 2011 at 9:36 AM, Jo. <nuagerouge2001@xxxxxxxxx> wrote: > > > > > Hi, > > Another solution couldbeto use the Office Open XML format tosavethe file as > > .xls. > Regards, > > jo > > > > >De : Tony Jones <tjones10707@xxxxxxxxx> > >À : php-objects@xxxxxxxxxxxxxxx > >Envoyé le : Mar 14 juin 2011, 17h 20min 10s > >Objet : Re: MYSQLTOEXCEL > > > > > >Isthis a onetimething or do needtocreate a php script > toallowsuserstoexport a > >file and saveit as an Excel file? Youcaneasilysendthe output of a > >mysqlstatementto an outfile and saveitwiththe extension .csv and > thenimport or > >open it in Excel, or youcansave or returnthe output in html format. > >Seethemysqlcommand on howtothis. > > > >Tony > >--- On Tue, 6/14/11, anandhKumar <hawkeranandh@xxxxxxxxx> wrote: > > > >From: anandhKumar <hawkeranandh@xxxxxxxxx> > >Subject: MYSQLTOEXCEL > >To: php-objects@xxxxxxxxxxxxxxx, vijayalakshmi6jun@xxxxxxxxx > > >Date: Tuesday, June 14, 2011, 10:40 AM > > > > > > > >Hi ToAll.... > > > >cananyone guide me... > > > >i need a code for mysql table record exporttoexcel file using php and > mysql > > > > >[Non-text portions ofthis message have beenremoved] > > > >[Non-text portions ofthis message have beenremoved] > > > > > > > > [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/
