Re: MYSQL TO EXCEL

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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/




[Index of Archives]     [PHP Home]     [PHP Users]     [PHP Soap]     [Kernel Newbies]     [Yosemite]     [Yosemite Campsites]

  Powered by Linux