Re: PHP+MySQL -> Excel ?
| From: | Rasmus Lerdorf | Date: | Fri, 17 May 2002 16:37:01 +0000 |
| Subject: | Re: PHP+MySQL -> Excel ? | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-98122@lists.php.net to get a copy of this message | ||
It is also possible to connect directly to MySQL from Excel via MyODBC.
-Rasmus
On Fri, 17 May 2002, Chris Boget wrote:
> > > Is it possible to create an excel file with some data from mySQL, using PHP
> > > ?
> > Yes if you know the file format for excel. If not then write your data into a
> > CSV file.
>
> I just output the data as regular HTML (tabled, usually) but send the following
> headers first:
>
> header("Content-Disposition: inline; filename=myfile.xls");
> header("Content-Description: PHP3 Generated Data");
> header("Content-type: application/vnd.ms-excel; name='excel'");
>
> The browser will take that to mean that an excel document is coming through
> and will open it up as such. Since excel understands HTML, your data will be
> displayed correctly. Usually.
> It's been working fine for us for years.
>
> Chris
>
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>